How do I format the date in a footer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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

HTH
Jason
Atlanta, GA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Footer date format 2
How do I format the date in a footer to display the month in lett. 1
Static Date in Header/Footer 3
Custom footer date format 2
Dates-Automatically entered in cells 7
footer date plus 3 months 4
How do i change the date format in a footer? 1
How do I add the last modified date to the footer in Excel? 1

Back
Top