Thread: Round dates to weekdays
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dhstein dhstein is offline
external usenet poster
  
Posts: 266
Default Round dates to weekdays
Using another cell and assume your date is in A1 --- =IF
(MOD(A1,7)<2,A1+2-MOD(A1,7),A1)

"Nan" wrote:

Is there a way that Excel can recognize if a date is a weekend and round it
to the nearest weekday?
--
TIA, Nan
Reply With QuoteReply With Quote