Calculate Holiday

  • Thread starter Thread starter Johnny
  • Start date Start date
J

Johnny

I need a forumula to autimatically caculate the actual date that employees
are off for Christmas based on the year. If the holiday falls on a Saturday,
then Friday is the day off. If on a Sunday, then Monday is the day off.

For example, Chirstmas in 2010 falls on a Saturday. The foruma needs to
return 12/24/10 as the day off. If I change the year to 2011, the day off
would fall on 12/26/10.

Hopefully the forumual would translate for Thanksgiving, Independence Day
and New Year's day as well.

Thank you,
 
While Biff's formula can easily be applied Independence Day and New Years,
Thanksgiving is a holiday that is always on the same day (but not date).
 
Back
Top