ExcelBanter - Find the date for monday prior to May 25th

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Find the date for monday prior to May 25th (https://www.excelbanter.com/excel-worksheet-functions/63176-find-date-monday-prior-may-25th.html)

Ralph Heidecke

Find the date for monday prior to May 25th

Can anyone provide a formula to find the Monday immediately prior to May
25th (the Canadain Holiday "Victoria Day") for any given year?

Thanks

Harlan Grove

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.

All times are GMT +1. The time now is 05:24 PM.