Thread: Formula has to take Monday if due date falls on a Sunday
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Formula has to take Monday if due date falls on a Sunday
=due_date+(WEEKDAY(due_date,2)5)+(WEEKDAY(due_dat e,2)=6)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Revathi" wrote in message
...
I have a large formula to calculate due date under different conditions.If
this due date is on a Saturday ,Sunday or on a holiday, it has to
cconsider
Monday or next working day, as applicable.


Reply With QuoteReply With Quote