Forum Discussion
175429
Sep 23, 2025Copper Contributor
Calculate Days in between Dates
Hey,
So I have a create date and a end date and I want to calculate the days in between those days, NOT counting the start date and weekends and the formula I am using is giving me the incorrect days:
It's giving me -2 when the correct days should be 0. You can't see it, but the L6-L34 are the holidays, which would be 7/4/2023.
Any advice on why this is happening would be greatly appreciated.
1 Reply
- Detlef_LewinSilver Contributor
=NETWORKDAYS(E68,D68,$L$6:$L$34)-1