View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Johnny[_5_] Johnny[_5_] is offline
external usenet poster
 
Posts: 1
Default Calculate Holiday

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,