Counting Date Changes
 

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(M7:P7),MAX(M7 :P7),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

Counting Date Changes
 

You have replies at your other post.

Ann wrote:

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(M7:P7),MAX(M7 :P7),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

Counting Date Changes
 

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)


"Ann" wrote in message
...
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(M7:P7),MAX(M7 :P7),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