calculating dates based on workdays only

M

mdameron

I need to calculate completion dates based on a start date, a
duration, and utilizing only work days.
 
G

Guest

-----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.
 
D

Daniel.M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Display weeks from a Milestone 0
Help using the Workday Function 1
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Calendar Logic: Recurring Dates 3
How to change date format to 7 working days a week in ms project 2010? 0
Calculating days spent to complete a task 2
How do I calculate future date after number of days 1

Top