Counting Date Changes

[Annabelle]

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

 

[goober]

=IF(AND(L7<>"",R7<>""),NETWORKDAYS(L7,IF(COUNT(M77),MAX(M77),Q7)),"")

This should do what you want.

Good Luck.