VBA: Input current YYYY-MM(+1) into a specific cell

[larinda4]

Good morning,

I'm having a hard time trying to figure out a macro that will update the yyyy-mm(+1) in a specific cell. It needs to include the ' at the beginning as that year-month is used to update the table below it.

Example: It is currently September 2022 right now. I would need the macro to select cell C2, and update it to '2022-10

I found this code below that I was thinking maybe I could alter?

Sub TestDate()
   Dim dtToday As String
   dtToday = Format (Date, "yyyy mm")
End Sub

Any help would be appreciated!

 

[larinda4]

It really depends on what it is you are trying to do.
If this follows you original question, and you ALWAYS want the following month, then use the logic from the line of code I gave you originally, i.e.

ActiveSheet.Name = Format(DateAdd("m", 1, Date), "yyyy mm") & "Final - By Region"

Thanks for taking the time to explain that to me. You've definitely saved me from potential errors in the future.

I wish I could buy you a coffee!

 

[Joe4]

You are welcome.
Glad I was able to help!

Yes, what you had originally would have worked for the rest of the month of September, but then when you hit October, it would returned "2022 Ocotber..." until October 16, at which point it would have switched over to "November 2022".