Holiday SetUp

  • Thread starter Thread starter Gdub
  • Start date Start date
G

Gdub

I'm endeavoring to set up an Employee Holiday and Vacation
tracker.
I need to auto-set permanent code that will always point
to the federally designated Holidays, regardless of year.
For example, Memorial Day is always on the last Monday in
May. When a new year rolls over, I need the Memorial Day
date field to display that year's last Monday date in May.
For the other holidays such as Christmas or New Year's
which occasionally fall on weekends, the basis will be if
it falls on Saturday, the recognized date is Friday or if
on Sunday, the recognized date is Monday. I've been
searching and have found some helpful info but haven't hit
paydirt yet.

Thanks much!
 
I'm endeavoring to set up an Employee Holiday and Vacation
tracker.
I need to auto-set permanent code that will always point
to the federally designated Holidays, regardless of year.
For example, Memorial Day is always on the last Monday in
May. When a new year rolls over, I need the Memorial Day
date field to display that year's last Monday date in May.
For the other holidays such as Christmas or New Year's
which occasionally fall on weekends, the basis will be if
it falls on Saturday, the recognized date is Friday or if
on Sunday, the recognized date is Monday. I've been
searching and have found some helpful info but haven't hit
paydirt yet.

Thanks much!
Click to expand...

It would be maybe fifteen minutes' work to manually fill in a Table
for the next ten years with this data - and probably ten times that at
least to write code to do it.

Note that it's often not just Federal holidays; many organizations
recognize local or regional holidays not celebrated elsewhere.
 
Back
Top