Automated dates

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

Paul Newcome

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