Active sheet name

[0 Agios]

I want to have this format in order to name a page without characters a [ ] : / showing dates for the pages name.
This works
ActiveSheet.Name = Format(Date, "DD-MM-YY")
But instead giving me todays date i want to get the date from range("F8") but keep the same format.
Thank you.

 

[Joe4]

ActiveSheet.Name = Format(Date, "DD-MM-YY")

As long as F8 contains a valid date entry (and not a text one), just use:

ActiveSheet.Name = Format(Range("F8"), "DD-MM-YY")

 

[0 Agios]

it worked thank you