Forum Discussion

jsicNP's avatar
jsicNP
Copper Contributor
Nov 30, 2023

header / footer: insert current date & current time

I tried to select from Header/Footer option for current date & current time.  The option appears to have disappeared.  So, I tried the MS suggestion =NOW() - but the time appears a a 24 hour clock.  ...
  • djclements's avatar
    djclements
    Dec 01, 2023

    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.

Resources