# Holidays not working in NETWORKDAYS Function

1. ## Holidays not working in NETWORKDAYS Function

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

2. ## Re: Holidays not working in NETWORKDAYS Function

Hi,

Why do you believe the answer is 18 & not 19?

There are 21 non weekend days, and you have two public holidays, 1 Jan and 27 Jan. You can't deduct 2 Jan since that's a Saturday and is already excluded from the 21 days

3. ## Re: Holidays not working in NETWORKDAYS Function

Originally Posted by Richard Buttrey
Hi,

Why do you believe the answer is 18 & not 19?

There are 21 non weekend days, and you have two public holidays, 1 Jan and 27 Jan. You can't deduct 2 Jan since that's a Saturday and is already excluded from the 21 days
We have three public holidays here in NZ in Jan.
1st
2nd
27th

So it should be 18 - I cant see why its not working ¯\_(ツ)_/¯

4. ## Re: Holidays not working in NETWORKDAYS Function

Let me move the 2nd to the 4th - and retry it.

5. ## Re: Holidays not working in NETWORKDAYS Function

In Jan, there are 10 weekend days (2,3,9,10,16,17,23,24,30,31) and 3 holidays (1,2,27), total is 10+3=13, but 2nd day is weekend and also holiday, so be counted 1 only , then total should be =13-1=12

Working day of Jan should be = 31-12=19 days.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1