Networkdays formula issue

[sunrise06]

I am getting incorrect results using networkdays. The calculation gives me 246 but it should be 245. I wonder if the fact it includes a leap year day it is not calculating correctly? Thoughts?

START DATE	END DATE	DAYS WORKED
7/1/2023	6/30/2024	246	removes 15 holidays; s/b 245
7/1/2023	6/30/2024	260	holidays excluded

List of 15 holidays:

7/4/2023

9/4/2023

9/25/2023

10/9/2023

11/10/2023

11/23/2023

11/24/2023

12/25/2023

1/1/2024

1/15/2024

2/19/2024

3/29/2024

4/15/2024

5/27/2024

6/19/2023

 

[Joe4]

No, it looks right to me.

Look at your last holiday: 6/19/2023
That is NOT in your date range.
So that means that there are just 14 holidays within 7/1/23 - 6/30/24, not 15!

 

[sunrise06]

O man you are a genius. I have been struggling with this for days. I even asked a co-worker to review. A fresh set of eyes always helps!

THANK YOU!

 

[Joe4]

You are welcome.

Yep, I have been there myself! Sometimes it is hard to "see the forest for the trees", and it takes a different set of eyes looking at it.