Help! New to Excel

Copper Contributor

 

Hello community!

 

Please forgive the newb questions I will undoubtedly be asking, starting with this one:

 

How do I format a single cell to show JUST the current year?

 

I am creating a document template that will be used and updated daily, possibly several times a day, throughout the year and needs to be saved for tax purposes annually.  

 

I would like the first row to include the document title which starts with the current year, in large bold text, followed by the rest of the title.  When I go to start 2022, I will save the template as a new doc for the year, and I would like for the year to automatically change from 2021 to 2022 when I do this.  I will only be accessing the template once a year and 'saving as' at the start of each year.  

 

I'm fairly confident this is not hard, but I cannot seem to figure it out!  Ugh. 


Thank you, in advance, for your help!

 

schmilary1

 

2 Replies
Try:
=YEAR(TODAY())
With your permission, if I can correct the language :)

=YEAR(TODAY())

Thank you
Nikolino