Forum Discussion

Copper Contributor

Feb 28, 2018

Formulas in the excel header

I have an excel file with a custom header, in the central part I have text and on the edges two different images, I require two things, add a date that changes every time the file is opened and I nee...

CARGA LABORAL.xls1 MB

excel

Excel Online

Formulas and Functions

Logaraj Sekar

Iron Contributor

Mar 01, 2018

RAFA Concha,

In header you just add &[date] after the text.

Current date will display with header.

RAFA Concha
Copper Contributor
Mar 01, 2018
BUT IF I WANT THE DATE IN DIFFERENT FORMAT, THAT IS SAY I WANT YOU TO SAY: PUEBLA, PUE. TO MONDAY, FEBRUARY 1, 2018
- SergeiBaklan
  Diamond Contributor
  Mar 01, 2018
  That's only with macro
  
  https://excelribbon.tips.net/T007990_Specifying_Date_Formats_in_Headers