Need Today function along with text

[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

 

[Michael J. Malinsky]

=YEAR(TODAY())-1

???

 

[Debra Dalgleish]

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.