| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting Date Changes | Excel Discussion (Misc queries) | |||
| Counting Date Changes | Excel Discussion (Misc queries) | |||
| Counting unique records based on date range | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Linear Mode
