If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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, |
#2
|
|||
|
|||
Calculate Holiday
Try this...
A1 = some date =A1+LOOKUP(WEEKDAY(A1,2),{1,6,7},{0,-1,1}) -- Biff Microsoft Excel MVP "Johnny" wrote in message ... 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, |
#3
|
|||
|
|||
Calculate Holiday
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). -- Best Regards, Luke M "T. Valko" wrote in message ... Try this... A1 = some date =A1+LOOKUP(WEEKDAY(A1,2),{1,6,7},{0,-1,1}) -- Biff Microsoft Excel MVP "Johnny" wrote in message ... 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, |
Thread Tools | |
Display Modes | |
|
|