calculating dates based on workdays only

  • Thread starter Thread starter mdameron
  • Start date Start date
M

mdameron

I need to calculate completion dates based on a start date, a
duration, and utilizing only work days.
 
-----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
Click to expand...
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.
 
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.
 
Back
Top