Dynamic Date cell --> to feed into NetWorkDays formula

Jessica Mahoney
edited 12/15/22 in Formulas and Functions

Hi all,

I'm very new to SS and maybe am going about this backwards....GOAL: I'm trying to create a running countdown between the current day and the due date of a project.

I figured out to use this formula: =NETWORKDAYS([Start Date]31, [End Date]28)

BUT I want this number to dynamically "count down" as we approach the end date. SO I would like to ideally put the START DATE as a dynamic date (aka todays date but update each day)....I haven't found how to do that, only static.

Help a noobie sister out? Thanks!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!