Footer date format

[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

 

[JE McGimpsey]

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

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