Function for Working Days Remaining

AAL

HI Smartsheet Help Team,

I use the following function to calculate the working days remaining.

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

However, I want to modify the function so that when it reaches the end date, it will become 0 because right now it becomes a negative figure.

Do you know how to change this function, please?

Thanks!

Shanky Paul

Hi,

Try the below formula:

=IFERROR(IF(NETWORKDAYS(TODAY(), [End Date]@row) >= 0, NETWORKDAYS(TODAY(), [End Date]@row), 0), "")

Thank you!

AAL

Thank you Paul, however, can you briefly explain this function to me, please?