Help With Remaining Work Days Formula

Nicole J

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.

Eric Law

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!

Eric Law

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!

Nicole J

Thanks, Eric. That did it.