Workdays Counter

RayF

Looking for help with the below formula. It countdowns the workdays from the start of the promotion to the completion date. The problem is once it goes past the completion date it starts counting backward. I would like it to stop counting once the completion date is hit.

Thank you for any assistance.

Amber Eakin

Try this! It will place a zero if the completion date is today or in the past. You could change the 0 to something else, like "Date Met" or whatever makes sense for you.

=IF([Completion Date]@row <= TODAY(), 0, IF(NOT(ISBLANK([Actual Launch Date]@row)), NETWORKDAYS(TODAY(), [Completion Date]@row)))

RayF

This worked perfectly. Thank you!

Amber Eakin

Try this! It will place a zero if the completion date is today or in the past. You could change the 0 to something else, like "Date Met" or whatever makes sense for you.

=IF([Completion Date]@row <= TODAY(), 0, IF(NOT(ISBLANK([Actual Launch Date]@row)), NETWORKDAYS(TODAY(), [Completion Date]@row)))

RayF

This worked perfectly. Thank you!

Amber Eakin

Great! If you would, please "accept" the answer if you're all set. Thank you!