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())
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allocate an income payment over a date range (tax years) 7
Need some PWA help 0
Template with fields and premade texts.. 0
Cell Referencing 5
Making "Change Highlighting" feature darker 1
calulation 1
Year End totals 7
Create dates for year, allow for leap year 8

Top