Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Date Changes
You have replies at your other post.
Ann 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(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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Date Changes
Additional criteria within an If can be obtained with OR , like so OR(L7="",R7=""), instead of your current single criteria -- HTH RP (remove nothere from the email address if mailing direct) "Ann" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Closed Date < 2 weeks of Open Date etc | Excel Worksheet Functions | |||
Counting Date Changes | Excel Discussion (Misc queries) | |||
date counting | Excel Worksheet Functions | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Date counting | Excel Programming |