View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Exclude Weekends

JJ,

What day would you want to return if the calculated start date was a Sunday?

Mike

"JJ" wrote:

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.