Formula for showing Previous Year - Current Year

C

Colin Hayes

Hi

I was trying to find a cell formula that would give the result

2010 - 2011.

Effectively it would return the previous year and the current year.

Can someone advise on this?

Thanks.
 
R

Ron Rosenfeld

Hi

I was trying to find a cell formula that would give the result

2010 - 2011.

Effectively it would return the previous year and the current year.

Can someone advise on this?

Thanks.
Click to expand...



=YEAR(TODAY())-1 & " - " & YEAR(TODAY())
 
Top