Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Annabelle
 
Posts: n/a
Default Calculating Networkdays - re-articulation

[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), so the calculation would use the last date change rather than L7.
2) Also, I don't want this count to appear until there is a completion
date
in R7.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating Cells n% displayed in a cell? Hannibal Excel Worksheet Functions 0 November 2nd 05 02:36 PM
NETWORKDAYS function problem Arvi Laanemets Excel Worksheet Functions 5 April 19th 05 08:10 AM
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) RICHARD Excel Worksheet Functions 1 March 15th 05 05:49 PM
AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! RICHARD Excel Discussion (Misc queries) 0 March 1st 05 01:53 PM
Calculating days between current date and a date in future NETWORKDAYS() function Faheem Khan Excel Worksheet Functions 2 February 10th 05 07:18 PM


All times are GMT +1. The time now is 10:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"