Hello, just note, date functions in Excel are volatile, making them both expensive to a workbook's recalculation and a moving target. Here's a block of code that you're looking for:
Sheets(1).Name = Format(Date, "mm-dd-yyyy")
Sheets(1).[a1] = Format(Date, "mm-dd-yyyy")
You can't use "/" in worksheet names, so you must be the bigger person and compromise here.