Help With Remaining Work Days Formula
All,
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.
Best Answer

Hello @Nicole J ,
I am a little confused about what you are trying to do. Can you give some examples? I THINK you can just use the following formula.
=IF(Today()<[Start Date]@row, NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(Today(), [End Date]@row))
Hope this helps!
Answers

Hello @Nicole J ,
I am a little confused about what you are trying to do. Can you give some examples? I THINK you can just use the following formula.
=IF(Today()<[Start Date]@row, NETWORKDAYS([Start Date]@row, [End Date]@row), NETWORKDAYS(Today(), [End Date]@row))
Hope this helps!

Thanks, Eric. That did it.
Help Article Resources
Categories
Check out the Formula Handbook template!