Hello,

I am trying to use the below VBA code to show the words "YTD May" or the
month 45 days ago.

Something is not correct in my code, because after running it displays "YTD 5"

Range("i3").Value = "YTD " & Month(Now() - 45)

How can I correct the formatting of the Month in this code?

Thank You