Need Today function along with text

  • Thread starter Thread starter Sandy
  • Start date Start date
S

Sandy

Hi!

I need a cell that reads "Year" and then uses the Today
function to get the year 2001, then the next cell to
read "Year" and uses the Today function to get the year
2002.

What's the best way to do this?

Sandy
 
For Year 2001: ="Year " & YEAR(TODAY())-2
For Year 2002: ="Year " & YEAR(TODAY())-1

The formula calculates the year of today's date, then subtract 1 or 2.
When you open this workbook in 2004, the cells will display Year 2002
and Year 2003.
 
Back
Top