LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JJ JJ is offline
external usenet poster
 
Posts: 122
Default Exclude Weekends

How do I set up the calander to exclude weekends in my schedule calculation?

Est Start Date 04/01/2010

Leadtime = 5 days

Actual start date is 09/01/2010 which is a Saterday.
It would be great to change the act start dte to 08/01/2010 Friday.

Tx.




 
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
Date count to exclude weekends Colin Hayes Excel Worksheet Functions 0 January 20th 09 01:24 AM
Exclude Weekends Kevin Charts and Charting in Excel 1 November 24th 08 08:00 PM
Exclude weekends when counting days only on day 29 or 30 Loren A - Huntley, Illinois Excel Worksheet Functions 3 February 19th 08 09:18 PM
How do I set up a calculation to exclude weekends? Ken Proj mgr Excel Worksheet Functions 6 February 8th 06 02:49 PM
calculation to exclude weekends Need2Know Excel Worksheet Functions 6 July 14th 05 09:01 PM


All times are GMT +1. The time now is 01:20 AM.

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

About Us

"It's about Microsoft Excel"