Thread: Weekends
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Weekends
"Peo Sjoblom" wrote...
One way

=IF(WEEKDAY(F9,2)5,F9-MOD(F9+5,7),F9-7)
....

Only works in the 1900 date system.

Reply With QuoteReply With Quote