I am trying to create a widget on Dashboard for project progression that includes factors such as "Total development cost to date" "Total development cost this calendar year" "Future spending in next 1,2,3, months". How do I program the cells in sheets to reflect these dates (ie. todays date plus 20 days for next months future spendings) but constantly updating with "today's" date so that when you look at Dashboard it'll always be updated to that day.
Help Article Resources
Check out the Formula Handbook template!