Formula for Memorial Day

How to set memorial day on a calendar

[Fortune Hunter]

I have an ASP calendar on one of the web sites that I created that simply looks like a standard block 30 or 31 day calendar with events showing up that the administrator puts in the back end.

It is for a race track and they have the live race days grayed out on the calendar (Friday through Sunday), but now they started racing on Mondays as well and want those days grayed out with the exception of Memorial Day and Labor Day. Labor day falls on the same day each year so I have a formula to "un-gray" that date.

Does anyone know if there is a formula that you can create in ASP to figure out Memorial day from year to year so that it automatically "de-grays" that day as well? I wasn't sure if there was a way to program a calendar to always know when Memorial day would occur from year to year.

Fortune Hunter

[LifeinAsia]

You're talking about the U.S., right? Like Labor Day, Memorial Day has the same characteristics for falling on the "same" day each year.

Labor Day is the first Monday in Sept.; Memorial Day is the last Monday in May. So you should be able to use similar logic to show Memorial Day.

[Fortune Hunter]

Asia:

I guess I didn't realize that it was the last Monday in may consistently. That will work fine as a formula. Thanks!

FH