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
 

On 12 Nov 2005 09:53:10 -0800, "Annabelle" 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(M 7: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


=IF(or(L7="",R7=""),"",NETWORKDAYS(L7,IF(COUNT(M7: P7),MAX(M7:P7),Q7)))





--ron

Counting Date Changes
 

Works great. Thank you for your help.

Counting Date Changes
 

On 12 Nov 2005 15:25:05 -0800, "Annabelle" wrote:

Works great. Thank you for your help.

You're welcome. Glad it's working.
--ron