Naming a Worksheet Today's date

[Factor3]

I've put together a Macro that does some reformatting of downloaded Stock prices, and I would like the end of the Macro to Rename the downloaded worksheet (Sheet1) Today's date in the format "dd.mm.yy"

I've tried:
Sheet1.Name = "Today()"

as well as
Sheet1.FormulaR1C1 = "=Today()"

But, I'm not having much luck.

Any ideas?

[mdmackillop]

Sheets("Sheet1").Name = Format(Now, "dd.mm.yy")

or maybe
ActiveSheet.Name = Format(Now, "dd.mm.yy")

[Bob Phillips]

I would always reverse the date, for sorting purposes



Sheet1.Name = Format(Date,"yyyy mm dd")

[Factor3]

That worked perfectly, Thanks SO much!!!