| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a date in a list | Excel Discussion (Misc queries) | |||
| Another Date issue. | Excel Worksheet Functions | |||
| how can i find a specific date of a database | Excel Discussion (Misc queries) | |||
| search for latest date | Excel Worksheet Functions | |||
| trying to find max date | Excel Worksheet Functions | |||
Linear Mode
