Hi Community,
I'm using the following formula to work out how many working days there are in the month.
=NETWORKDAYS(A2,EOMONTH(A2,0),Holidays[Date])
We have 3 public holidays here in NZ in Jan, but for some reason, the formula I'm using is not picking up the data I've designated for holidays.
It would be a great help if someone can spot where I'm going wrong!
Book Holidays.xlsx
Obviously, as the month changes the public holidays should be taken into account
Thanks
Tony
Bookmarks