Working Days Remaining

Fabian Smith

=IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row))

I'm using the formula above, but I want to stop the workdays remaining count to stop when the task is complete.

Paul Newcome

Are you capturing the date when a task is completed?

Fabian Smith

No, I just have the end date. Is there a formula for "Date of Completion" that captures the date when the task is 100% complete?

Andrée Starå

Hi @Fabian Smith

I hope you're well and safe!

You could use a Workflow combined with the Record a Date Action to store the date when it's 100% Complete.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Paul Newcome

You could just get it to stop when the end date is reached by adjusting the formula like so:

=IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", MIN(NETWORKDAYS(TODAY(), [End Date]@row), 0))