Maybe:
If you want to make the active sheet name become todays date then maybe:Aprils = Left(ActiveSheet.Name, 7)
ActiveSheet.Name = Format(Date, "yyyy.mm.dd")
Maybe:
If you want to make the active sheet name become todays date then maybe:Aprils = Left(ActiveSheet.Name, 7)
ActiveSheet.Name = Format(Date, "yyyy.mm.dd")