Naming the Sheet after the date

[hypnoshrew]

Hi,

I am using Excel 2007 and hope to create a simple macro that changes the Sheet Name to the date. But I want the date to exclude the year for the sake of space, or in a format similar to "MM-DD". ie. If the macro ran today, the sheet name would change to "11-09".

Been trying a line of code like this:

ActiveSheet.Name = Month(Date) - Day(Date)

But that's calculating a new number and not formatting the way I'd hope.

Thanks.

 

[mikerickson]

ActiveSheet.Name = Format(Date, "mm-dd")

 

[hypnoshrew]

Wonderful! Thanks so much and for the quick response!

(My first attempt at creating a macro, I figured the solution had to be quite simple.)