Hello,
I want to create a new worksheet and give it the name of
the date
I use this code but I get error 1004

Worksheets.Add(After:=Worksheets(Worksheets.Count) ).Name
= DateValue(Now)

Can you please tell me what I am doing wrong.
I have checked help files and the internet I cant get
working

Thanks for you time.