Excel Formula for Christmas and New Year

[Chris Waller]

Hi All,

I have the following formula =DATE(B50,12,25)+CHOOSE(WEEKDAY(DATE(B50,12,25)),1,0,0,0,0,0,2) which gives the date of the Christmas holiday. What I am trying to do in the next column is put a formula that will show Christmas Day if the date is the 25th December and Substitute Christmas Holiday if the date is after the 25th. I've tried all different combinations and I cannot get this to work. I am obviously doing something wrong because if I just use the date, I can get this to work.

Can someone give me any clues how to get the my formula for the days to work when using the formula above.

TIA

 

[mikerickson]

For your overall project, have you looked at NETWORKDAYS.INTL or WORKDAY.INTL that let you specify which holdays to account for and when the weekend is?

 

[Fluff]

How about

=IF(DAY(B51)=25,"xmas","subs")

where B51 has the other formula

 

[Chris Waller]

How about

=IF(DAY(B51)=25,"xmas","subs")

where B51 has the other formula

Fluff,

Thanks very much for your prompt response. It works a treat.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Chris Waller]

For your overall project, have you looked at NETWORKDAYS.INTL or WORKDAY.INTL that let you specify which holdays to account for and when the weekend is?

mikerickson,

Thanks for your prompt reply. I must admit that I am trying to do something as a matter of urgency, therefore I haven't had time to look at NETWEOKDAYS.INTL or WORKDAY.INTL yet, but will look at it when I have slightly more time than I do at present.

Thanks again for your help.