Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workdays Counted - re-articulated question
[re-articulation of a previously asked question]
BACKGROUND I'm calculating workdays to determine a days count between the LAST updated date and the completed date; this is to measure our scheduling accuracy. Can you assist? Current formula is: =IF(OR(R7=""),"",NETWORKDAYS(L7,R7))-1 a) the original date is L7 b) the completed date is R7 c) M7 through Q7 are updated delivery dates (date changes) REQUEST New formula result required: the difference between the LAST date updated and the completion date. 1) if the schedule doesn't change, the difference would be between L7 and R7. It is possible that the date could have changed up to 5 times (M7 - Q7). 2) Also, I don't want this count to appear until there is a completion date in R7. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need data counted when changes are made | Excel Discussion (Misc queries) | |||
workdays question/help | Excel Discussion (Misc queries) | |||
How can i sum up numbers which are counted on a date. | Excel Worksheet Functions | |||
Can comment indicators be counted? | Excel Programming | |||
Validation by counted chars | Excel Programming |