Thread: Trace Dependents - not working
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
  
Posts: 846
Default Trace Dependents - not working
Using Excel 2007

In cell (I1) on table Input!I1, I have the equation
=DATE(C1,C2+1,0)

On a different sheet, in the same workbook I have the equation

=NETWORKDAYS(TODAY(),Input!I1,Holiday)

When I'm on I1 and select Trace Dependents - I get nothing
When I'm on the second formulat and select Trace Precendents - I get I1 as
one of the precendents - what is going on?
Reply With QuoteReply With Quote