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
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 |
#3
|
|||
|
|||
Counting Date Changes
Works great. Thank you for your help.
|
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Counting unique records based on date range | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions |