Counting Date Changes

[Ann]

I'm using this formula to calculate schedule changes by workday. In
this example, the difference between the original date of 8/18 and the
latest move date of 9/10 is 17 workdays.


What I now need to do is NOT populate Col T until I have a date in Col
R, but having difficulty adding this additional criterion. Can you
assist?


=IF(L7="","",NETWORKDAYS(L7,IF(COUNT(M77),MAX(M77),Q7)))


Col L Orig 08/18/05
Col M Move1 08/22/05
Col N Move2 08/30/05
Col O Move3 09/10/05
Col P Move4
Col Q Target 08/18/05
Col R Arrive
Col S (blank)
Col T Accuracy 17

 

[Dave Peterson]

You have replies at your other post.

I'm using this formula to calculate schedule changes by workday. In
this example, the difference between the original date of 8/18 and the
latest move date of 9/10 is 17 workdays.

What I now need to do is NOT populate Col T until I have a date in Col
R, but having difficulty adding this additional criterion. Can you
assist?

=IF(L7="","",NETWORKDAYS(L7,IF(COUNT(M77),MAX(M77),Q7)))

Col L Orig 08/18/05
Col M Move1 08/22/05
Col N Move2 08/30/05
Col O Move3 09/10/05
Col P Move4
Col Q Target 08/18/05
Col R Arrive
Col S (blank)
Col T Accuracy 17

 

[Bob Phillips]

Additional criteria within an If can be obtained with OR , like so

OR(L7="",R7=""),

instead of your current single criteria

--

HTH

RP
(remove nothere from the email address if mailing direct)