Holiday Calculations

[dt01234]

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

 

[fairwinds]

Welcome to the board!

Try:

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

with the year in A1

 

[barry houdini]

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)

 

[fairwinds]

on or before the 25th of may

Maybe we have to go to Canada and check it out.

 

[dt01234]

Thank you, It worked.