Thread: if "x" days is more fall on weekend return following monday
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
  
Posts: 1
Default if "x" days is more fall on weekend return following monday

You say you want to return a date 3 days later unless it falls on the
weekend, in which case return following Monday. This isn't always the
same as adding 3 workdays and certainly won't ever be the same if C1 is
10

I suggest

=WORKDAY(A2+$C$1-1,1)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=559108

Reply With QuoteReply With Quote