Help With Remaining Work Days Formula
I'm in need of a formula that calculates remaining work days within a "start date" and an "end date".
I came up with this: =IF(ISERROR(NETWORKDAYS(TODAY(), [Start Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) - which works fine as long as "today" currently falls within the "start date" and "end date".
But, I need it to account for start dates in the future. So, if my "start date" is 03/01/2024 and my "end date" is 02/29/2025, the above formula spits out "500" (but it should be 261).
Any help is appreciated.
Help Article Resources
Check out the Formula Handbook template!