Forcasting for a multiyear period

[nelsok]

I wasnt sure what to give as a title for my question.

What i have:

cell a1 is an input cell for a year the year is "2005"

then the next 20 cells in row 1 are taking cell a1 plus 1.

so cell a2 would be "2006" and cell a3 would be "2007".

I was wondering if anyone knows a way to make it so I can have th
cells look like this. "2005-06" or "2005-2006" or "05-06"

the cell a1 input would be one of the example above and then cell a
would be "2006-2007".

thanks for the help

 

[Anne Troy]

Put 2005-2006 in a1 and type this into A2:
=LEFT(A1,4)+1&"-"&RIGHT(A1,4)+1
Copy down...
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Roger Govier]

Hi

One way, Format>Cells>Number>Custom> 0000 - 0000
In A1 enter 20052006 and it will appear as 2005 - 2006
In A2 =A1+10001
Copy down as far as you need

 

[nelsok]

thanks... both ways do exactly what i need them to