Footer date format

F

Francis Hookam

Footer date format

Can one vary the format of the date in a footer?

Mine comes out as dd/mm/yyyy whereas I should prefer d mmm YY but on
occasions might choose another format

Francis Hookham
 
J

JE McGimpsey

Francis Hookam said:
Can one vary the format of the date in a footer?

Mine comes out as dd/mm/yyyy whereas I should prefer d mmm YY but on
occasions might choose another format
Click to expand...

You can do this with VBA:

Public Sub DateInFooter()
Dim ws As Worksheet
For Each ws In ActiveWindow.SelectedSheets
ws.PageSetup.LeftFooter = Format(Date, "d mmm yy")
Next ws
End Sub
 
Top