Fiscal Year Question

[rival2031]

Is it possible to subtract a year from a cell that has 2012/2013 in it? For example, if A1 says 2012/2013, how can I get 2011/2012 to display in A2? Thanks in advance...

[judgeh59]

=RIGHT(A1,4)-2&"/"&LEFT(A1,4)

try that.....It assumes a lot....

[judgeh59]

sorry this works for Col B not A2.....I can fix that if you need me to

[rival2031]

Bingo... worked! Thank you kind sir.