Forcasting for a multiyear period
 

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 the
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 a2
would be "2006-2007".

thanks for the help.


--
nelsok
------------------------------------------------------------------------
nelsok's Profile: http://www.excelforum.com/member.php...o&userid=30682
View this thread: http://www.excelforum.com/showthread...hreadid=503445

Forcasting for a multiyear period
 

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

"nelsok" wrote in
message ...

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 the
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 a2
would be "2006-2007".

thanks for the help.


--
nelsok
------------------------------------------------------------------------
nelsok's Profile:
http://www.excelforum.com/member.php...o&userid=30682
View this thread: http://www.excelforum.com/showthread...hreadid=503445

Forcasting for a multiyear period
 

Hi

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

--
Regards

Roger Govier


"nelsok" wrote in
message ...

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 the
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 a2
would be "2006-2007".

thanks for the help.


--
nelsok
------------------------------------------------------------------------
nelsok's Profile:
http://www.excelforum.com/member.php...o&userid=30682
View this thread:
http://www.excelforum.com/showthread...hreadid=503445

Forcasting for a multiyear period
 

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


--
nelsok
------------------------------------------------------------------------
nelsok's Profile: http://www.excelforum.com/member.php...o&userid=30682
View this thread: http://www.excelforum.com/showthread...hreadid=503445