Thread: Find the date for monday prior to May 25th
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Find the date for monday prior to May 25th
Ralph Heidecke wrote...
Can anyone provide a formula to find the Monday immediately prior to May
25th (the Canadain Holiday "Victoria Day") for any given year?

=DATE(y,5,25)-WEEKDAY(DATE(y,5,25),3)

assuming you want 25 May if it happens to be a Monday.

Reply With QuoteReply With Quote