Holiday Calculations

dt01234

New Member
Joined
Sep 17, 2008
Messages
2
Does anyone know how to calculate a national holiday from year to year.
In canada Victoria day falls on the monday on or before the 25th of may.
PLease help
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Welcome to the board!

Try:

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

with the year in A1
 

barry houdini

MrExcel MVP
Joined
Mar 23, 2005
Messages
20,825
My understanding is that it must be before the 25th, for instance in 2009 Victoria day is Monday 18th May. In which case you need to amend Fairwinds' suggestion to

=DATE(A1,5,24)-WEEKDAY(DATE(A1,5,24),3)
 

Watch MrExcel Video

Forum statistics

Threads
1,102,344
Messages
5,486,310
Members
407,539
Latest member
ltwkuav

This Week's Hot Topics

Top