CountDown Formula with Automation

Harley Esguerra

Hello,

I created this countdown sheet and I added an automation to update todays date. I want to create a formula to countdown the number business days from my event day. What formula can I use OR is there a different way to do this?

KPH

You can use the NETWORKDAY or NETWORKDAYS functions to calculate the number of business days between the two dates:

NETWORKDAY Function

Returns the number of working days between two dates. Adds 1 day to the result if the start date is a non-working day.

https://help.smartsheet.com/function/networkday

NETWORKDAYS Function

Returns the number of working days between two dates.

https://help.smartsheet.com/function/networkdays