Creating an Expiration Countdown


I need to create a tracker that counts down when a contract is going to expire. I am trying to use NETWORKDAYS function and it is not working for me. Does anyone have any suggestions on how I can do this?

Things to keep in mind is that this would be a living spreadsheet so the days to expiration would have to change as the dates change!

Thank you for your help and advice in advance! 😀


  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭

    Hi Robin,

    This should work for you. You can change the funtion to NETWORKDAYS if you don't want to include weekends. Change my [expiration date] to the name of your column with the expiration date. That column must be set with a date property. The column with the formula below needs to be a number/text column.

    =NETDAYS(Today(), [expiration date]@row)



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!