Dynamic Date cell --> to feed into NetWorkDays formula
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!
Help Article Resources
Check out the Formula Handbook template!