Dynamic date with String

[xcelnovice]

Hi, I have the below currently

Cells(1, 1) = “Report Month: October 2017”

I’d love me to retain the “Report Month” but make the October 2017 be dynamic but on a one month lag. So if I run it in December it will return a November date.

 

[FormR]

Hi, you could try like this:

Cells(1, 1) = "Report Month: " & Format(Date - Day(Date), "MMMM YYYY")

 

[xcelnovice]

That did it! Thanks so much!