Date Formula Help Needed!

crystal.schroeder

My current formula seems to count weekends and then also seems to count the day of as a day too - can someone help me rewrite this so days until due for 1/17/2025 would show as 1 and not 2, and then also skip weekends?

Formula in case its hard to see below -

=IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row), "")

Leibel S

You can just add a minus 1

=IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row) - 1, "")

Leibel S

You can just add a minus 1

=IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row) - 1, "")