i've recorded a macro that creates a new sheet. but how do i get the new sheet's tab name to be todays date. For example if i create a new sheet tomorrow the i want the tab to be named 09/04/2008 or something similar.
Sub newsheet()
'
' newsheet Macro
' Macro recorded 08/04/2008 by JSmith3
'

'
    Sheets("Template").Select
    Sheets("Template").Copy Before:=Sheets(1)
    Range("L21").Select
End Sub