Hi all,

Using Excel 2010.
I am trying to determine the number of operating days for Jan, 2015.

It should be 18 since New Year's Day is on Thursday, 1/1/15 and MLK Day is on Monday 1/19/15 - but I am receiving 20 days

My formula:

=NETWORKDAYS(A2,EOMONTH(A2,0),lstHolidays)

Where lstHolidays is a list of US Banking Holidays

I also tried,

=NETWORKDAYS.INTL(A2,EOMONTH(A2,0),1,lstHolidays)

Where 1 defines the Weekend Type as Sat,Sun

Both formulas return 20 days.

Any thoughts as to what I am doing wrong?

thx
w