View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charles C.
 
Posts: n/a
Default workdays formula ends on weekend date

I'm trying to calculate end dates similar to MS Project based upon a start
date and duration in workdays.

Start Date = 1/3/2006
Workdays = 28 - 1 day adjustment to get the END DATE
Holidays = ignore for now, not using it

Therefore... formula is WORKDAYS(1/3/2006,28)-1 = 2/9/2006
this is okay, but when increased to 29 days the end date should be 2/10/2006
but Excel jumps to 2/12/2006 which is a Sunday.

Why? What am i doing wrong?