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), "")
Best Answer
-
You can just add a minus 1
=IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row) - 1, "")
Answers
-
You can just add a minus 1
=IFERROR(NETWORKDAYS(TODAY(), [Reporting Due Date]@row) - 1, "")
