Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I currently have a worksheet where I can enter the start date on one cell and
the number of weeks to be worked and get the estimated out date. I now need to take the estimated out date and the actual out date and get the number of weeks between the two in order to calculate my estimated budgetary savings. |
#2
![]() |
|||
|
|||
![]()
Hi
Have a look at the NETWORkDAYS function. You will need the Analysis Add In to use it. =NETWORKDAYS(End Date,Start Date)/5 will give you the number of weeks between the 2 dates. If you want to include all days between the 2 dates simply use =A1-B1 A1 = End Date B1 = Start Date HTH Michael -- Michael Mitchelson "klillestol" wrote: I currently have a worksheet where I can enter the start date on one cell and the number of weeks to be worked and get the estimated out date. I now need to take the estimated out date and the actual out date and get the number of weeks between the two in order to calculate my estimated budgetary savings. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with week day count with range | Excel Worksheet Functions | |||
user defined function | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
How do I do count calculations ignoring duplicate values | Excel Discussion (Misc queries) | |||
Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel |