LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

Use the NETWORKDAYS worksheet function. Make sure the
Analysis ToolPak is installed under Tools Add-Ins. See
XL help file.

HTH
Jason
Atlanta, GA

-----Original Message-----
How would you advise going about the following.

I have a column for project start dates. I have another

column indicating
duration for the project in terms of work days. How

would you calculate the
end date? Adding the duration would not account for

weekend? Thoughts?
.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Function to sort days Terry Excel Worksheet Functions 0 March 12th 05 10:25 PM
The left function does not work when displaying times, how is thi. Nambo27 Excel Worksheet Functions 3 February 25th 05 06:46 PM
Is there a WorkDay() type function that count all days except tho. Dark Skunk Excel Worksheet Functions 8 February 15th 05 08:37 PM
Concatenate Function will not work Chuck W Excel Discussion (Misc queries) 4 January 31st 05 11:41 PM
Adding text before a function Eric Excel Worksheet Functions 1 November 3rd 04 06:57 PM


All times are GMT +1. The time now is 07:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"