A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

calculating dates based on workdays only



 
 
Thread Tools Display Modes
  #1  
Old July 19th, 2004, 08:29 PM
external usenet poster
 
Posts: n/a
Default 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  
Old July 20th, 2004, 03:48 AM
Daniel.M
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 08:58 PM.


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