ExcelBanter - Counting Date Changes

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting Date Changes (https://www.excelbanter.com/excel-discussion-misc-queries/55163-counting-date-changes.html)

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

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

This should do what you want.

Good Luck.

--
goober
------------------------------------------------------------------------
goober's Profile: http://www.excelforum.com/member.php...o&userid=19838
View this thread: http://www.excelforum.com/showthread...hreadid=484556