Automated dates
Options
Dave Godfrey
✭✭✭✭
I am trying the set up a dashboard using a rollup sheet.
I am trying to automate the start date so that it is always set to the 1st of the month or would it need to be manually changed every month?
Thanks
Dave
Comments
-
Give this a try...
=MONTH(TODAY()) + "/" + 1 + "/" + YEAR(TODAY())
What it does is displays the month for whatever TODAY is.
Then a /
Then 1
Then another /
And finally the year for whatever TODAY is.
Below is the result