Excel Header Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2565553%22%20slang%3D%22en-US%22%3EExcel%20Header%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2565553%22%20slang%3D%22en-US%22%3E%3CP%3EI%20would%20like%20to%20be%20able%20to%20use%20a%20header%20in%20excel%20with%20the%20formula%20%22%3Dtoday()%22.%20I%20know%20I%20can%20add%20todays%20date%20in%20the%20header%20but%20I%20was%20hoping%20to%20have%20it%20auto%20calculate%20every%20day%20I%20open%20the%20sheet%20to%20read%20for%20example%3A%20Tuesday%2C%20July%2020%2C%202021%2C%20Wednesday%2C%20July%2021%2C%202021%20etc....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2565553%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2565594%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Header%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2565594%22%20slang%3D%22en-US%22%3ECould%20you%20please%20clarify%20what%20you%20exactly%20mean%20with%20a%20Header.%20Are%20you%20talking%20about%20the%201st%20(or%202nd%2C%203rd...)%20row%20of%20a%20worksheet%20or%20the%20Header%20row%20of%20a%20Table%3F%3CBR%20%2F%3EIf%20the%20latter%20that's%20not%20possible%2C%20a%20Table%20Header%20must%20have%20static%20values%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2565598%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Header%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2565598%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20header%20that%20isn't%20displayed%20until%20it's%20printed.%20Inserting%20Header%2FFooter.%20Under%20Page%20Setup%20-%20Header%2FFooter.%20If%20I%20choose%20to%20insert%20header%2Ffooter%2C%20I%20can%20choose%20certain%20header%20and%20footer%20elements%20like%20page%20%23%2C%20%23%20of%20pages%2C%20current%20date%2C%20current%20time%20etc....%20I%20want%20the%20current%20date%2C%20but%20I%20want%20it%20to%20be%20in%20the%20date%20format%20of%20Day%20of%20the%20Week%2C%20Date%2C%20and%20Year%20(Tuesday%2C%20July%2020%2C%202021)%20and%20not%20just%207%2F20%2F21.%20thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I would like to be able to use a header in excel with the formula "=today()". I know I can add todays date in the header but I was hoping to have it auto calculate every day I open the sheet to read for example: Tuesday, July 20, 2021, Wednesday, July 21, 2021 etc....

 

thanks

3 Replies
Could you please clarify what you exactly mean with a Header. Are you talking about the 1st (or 2nd, 3rd...) row of a worksheet or the Header row of a Table?
If the latter that's not possible, a Table Header must have static values

The header that isn't displayed until it's printed. Inserting Header/Footer. Under Page Setup - Header/Footer. If I choose to insert header/footer, I can choose certain header and footer elements like page #, # of pages, current date, current time etc.... I want the current date, but I want it to be in the date format of Day of the Week, Date, and Year (Tuesday, July 20, 2021) and not just 7/20/21. thanks

@7Rings 

As far as I know the only way to achieve this is to call VBA to the rescue, adding something like below to ThisWorkbook (open the VBA Editor with Alt+F11)

 

 

Private Sub Workbook_BeforePrint(Cancel As Boolean)
	ActiveSheet.PageSetup.CenterHeader = Format(Date(),"dddd, mmmm dd, yyyy")
End Sub

 

Demo.png