Forum Discussion

175429's avatar
175429
Copper Contributor
Sep 23, 2025

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.

 

Resources