January 1st Holiday with WORKDAYS formula

[KapsaKid]

Hi, I'm new to the boards. So hoping you can help me. I'm using the WORKDAYS formula to calculate due dates for my tasks. I've entered the holidays in the correct format (=Date(YYYY,MM,DD)). The formula will work with the holidays for all except New Year's Day, 1/1. Not sure why. Any insight on this?

 

[Dave Patton]

Can you give an example of your calculation and the formula?

Excel 2010
	B	C	D	E
1	Start	End	Days	Holidays
2	28-Dec-17	11-Jan-18	10	1-Jan-18
3				14-Feb-18
4
4b

Cell Formulas
Range	Formula
D2	=NETWORKDAYS(B2,C2,E2:E3)

 

[Dave Patton]

I put the wrong example in my post.

consider

Excel 2010
	A	B	C	D	E
1		Start	Days		Holidays
2					1-Jan-18
3					14-Feb-18
4
5		28-Dec-17	10	12-Jan-18
6
4b

Cell Formulas
Range	Formula
D5	=WORKDAY(B5,C5,E2:E3)