If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
calculating dates based on workdays only
-----Original Message----- I need to calculate completion dates based on a start date, a duration, and utilizing only work days. . When I was running version 97, there was a WORKDAY function that calculated the number of workdays between a range and allowed you the option to exclude weekends and holidays. I have excel 2000 and that function is not loaded on my PC so I am not sure if the function is still available. |
#2
|
|||
|
|||
calculating dates based on workdays only
Hi,
Apart from weekends and holidays, are people working around the clock to do your tasks or do you have shifts (8:00 to 17:00)? In other words, are you counting all the hours of week days or only during specific hours (8:00 to 17:00)? Regards, Daniel M. "mdameron" wrote in message om... I need to calculate completion dates based on a start date, a duration, and utilizing only work days. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Calculating Calendar Dates | V-Man | Worksheet Functions | 7 | July 19th, 2004 06:50 PM |
Calculating Due Dates | Ajit | Worksheet Functions | 1 | June 10th, 2004 07:24 AM |
Calculating days between two dates and multiply them with different numbers | [email protected] | Worksheet Functions | 3 | June 1st, 2004 06:36 PM |
Calculating age from birth dates | John Nall | Worksheet Functions | 2 | September 15th, 2003 04:39 AM |