Sub aaa()
Dim sht As Worksheet, i&, s$
Application.DisplayAlerts = False
On Error Resume Next
Set sht = Sheet1
s = Format(Now(), "dd") & "日"
Sheets(s).Delete
sht.Copy after:=sht
ActiveSheet.Name = s
ActiveSheet.Select
Application.DisplayAlerts = True
End Sub