Thread: Want only current year in header/footer - How?
View Single Post
 
Old 12-05-2019, 11:29 AM
DBlomgren DBlomgren is offline Windows 10 Office 2016
Advanced Beginner
  
Join Date: Feb 2014
Location: New York, USA
Posts: 82
DBlomgren is on a distinguished road
Default Want only current year in header/footer - How?
Hi, all,
I want to have just the current year in a header in Excel. I'm too lazy to update it every year. So how can I insert just the year in a header (or footer)?

I've tried formulas used in cells:
=YEAR(TODAY())
&YEAR(TODAY())
and they don't work. Does anyone know the magic formula? I want it to appear as:
Text text text 2019
Reply With Quote