Workday remaining formula

Nicolette Thomas

Hi all,

Does anyone have a simple workday remaining formula that they can share. I am trying to find out the number of days remaining from the end date. Meaning the end date of my project is May 7th so I want it to display that I have 4 days remaining. Anyone have a formula?

Heather Duff

Hi @Nicolette Thomas ,

This may be helpful: https://help.smartsheet.com/function/networkdays

So, your formula would look something like this:

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

Hope this helps!

Best,

Heather

Heather Duff

Hi @Nicolette Thomas ,

This may be helpful: https://help.smartsheet.com/function/networkdays

So, your formula would look something like this:

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

Hope this helps!

Best,

Heather