Forum Discussion
header / footer: insert current date & current time
jsicNP In reference to the Page Setup screenshot you shared, just click the "Custom Header..." or "Custom Footer..." button. The dialog box that opens contains the buttons to insert Date and Time. The code used for Date and Time within Headers/Footers is &[Date] and &[Time]. Also worth mentioning, the date format used in Headers/Footers is based on the Regional & Language Settings on your computer and cannot be customize directly in Excel.
Thanks for the visual. Below is what I get when I click Header/Footer.
I don't understand, I used to have this feature. It appears to have disappeared. Any suggestions?
Thank you
jsicNP In reference to the Page Setup screenshot you shared, just click the "Custom Header..." or "Custom Footer..." button. The dialog box that opens contains the buttons to insert Date and Time. The code used for Date and Time within Headers/Footers is &[Date] and &[Time]. Also worth mentioning, the date format used in Headers/Footers is based on the Regional & Language Settings on your computer and cannot be customize directly in Excel.
- Thanks for the detailed response. I appreciate your diligence.