How do I format the date in a footer?

R

RBono

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

Jason Morin

Try:

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

HTH
Jason
Atlanta, GA
 
Top