Dynamic Date cell --> to feed into NetWorkDays formula

Jessica Mahoney · 12/14/22

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!

Andrée Starå · 12/15/22

Hi @Jessica Mahoney

I hope you're well and safe!

Try something like this.

=NETWORKDAYS(TODAY(), Due@row)

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå · 12/15/22

@Jessica Mahoney

Excellent!

Happy to help!

Andrée Starå · 12/15/22