Forum Discussion
Solved
How to change date format in Excel footer
I am creating a template for a Spanish project. In Spanish, the dates are formatted dd/mm/yyyy. How can I change the format in my footer ? The current entry is: Actualizado &[Date]
This produces mm/dd/yyyy result.
Thanks
- I finally found a way to do this! I'll post the information here for anyone else looking for a way to accomplish this. It is from this article.
https://www.extendoffice.com/documents/excel/4266-excel-format-date-in-header.html
I created a 3 line VB script:
Sub add_date_footer()
ActiveSheet.PageSetup.LeftFooter = Format(Date, "dd-mm-yyyy")
End Sub
When I ran it, it changed the date in my footer from mm/dd/yyyy to dd/mm/yyyy.
Thanks for all the suggestions.
7 Replies
- surround with text(your formula,”dd/mm/yyyy”)
Thanks for the suggestion. Maybe I didn't format this correctly. It's not working for me.
I tried:
Actualizado (&[Date],”dd/mm/yyyy”)
which returns the results:
Actualizado (12/26/2022,”dd/mm/yyyy”)
I tried a few other attempts, but they only returned the exact expression I entered.
Again, this is in a footer. I don't know if that makes a difference. Do you have another suggestion for the format ?
Thanks again for your assistance.