ExcelBanter - How do I format the date in a footer?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I format the date in a footer? (https://www.excelbanter.com/excel-discussion-misc-queries/12405-how-do-i-format-date-footer.html)

RBono

How do I format the date in a footer?

Is it possible to display the date in a footer using the &[DATE] as a
alphabetic month instead of a numerical value?

Jason Morin

Try:

ActiveSheet.PageSetup.RightFooter = Format(Now, "mmmm")

HTH
Jason
Atlanta, GA

-----Original Message-----
Is it possible to display the date in a footer using the
&[DATE] as a
alphabetic month instead of a numerical value?
.

All times are GMT +1. The time now is 09:58 PM.