View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_2_] MyVeryOwnSelf[_2_] is offline
external usenet poster
 
Posts: 143
Default Calculate Future Date but don't want

What formula would I used to calcuate a future date and if it lands on
a weekend to "round up" the future date to the following Monday (or
round down the Friday)


If the future date is in A1, here's one way to round up weekends to Monday:
=A1+IF(WEEKDAY(A1,2)5,8-WEEKDAY(A1,2),0)

And to round down to Friday:
=A1-MAX(0,WEEKDAY(A1,2)-5)