Hello,

I frequently use fiscal year representations of years, and would like to be
able to use this in a date field where the year can be incremented by a
formula.
for example, the fiscal year from July 2002 through June 2003 is frequently
written,

FY 2002 - 2003 or sometimes, just

2002 - 2003

is there any way that I can put something like

FY 2002 - 2003

into Cell A1, and then put a formula like...

=A1 + 1

or maybe
=A2 + 365

into Cell B1 and have the value in B1 show as

2003 - 2004

or

FY 2003 - 2004


Can this be done? If it can't be done, perhaps it can be a suggestion for
future versions of Microosft products.

Thanks

Keith

Keith,

there are several ways to tackle this. One way is to put the number
2002 in a cell, say K1. Then let us say you start with your fiscal
years in A3.

="FY "&$K$1+(ROW()-ROW($A$3))&" - "&$K$1+(ROW()-ROW($A$3))+1

Does this help?

Kostis Vezerides

=LEFT(A1,4)+1&" - "&RIGHT(A1,4)+1

Vaya con Dios,
Chuck, CABGx3



"keith" wrote:

Hello,

I frequently use fiscal year representations of years, and would like to be
able to use this in a date field where the year can be incremented by a
formula.
for example, the fiscal year from July 2002 through June 2003 is frequently
written,

FY 2002 - 2003 or sometimes, just

2002 - 2003

is there any way that I can put something like

FY 2002 - 2003

into Cell A1, and then put a formula like...

=A1 + 1

or maybe
=A2 + 365

into Cell B1 and have the value in B1 show as

2003 - 2004

or

FY 2003 - 2004


Can this be done? If it can't be done, perhaps it can be a suggestion for
future versions of Microosft products.

Thanks

Keith

This might work for you, if you're just looking for a way to increment the
displayed value of your Fiscal Years (like for column headers):

In Cell A1:
FY 2002 - 2003

In Cell B1:
="FY " & RIGHT(A1,4) & " - " & RIGHT(A1,4)+1

HTH,
Elkar


"keith" wrote:

Hello,

I frequently use fiscal year representations of years, and would like to be
able to use this in a date field where the year can be incremented by a
formula.
for example, the fiscal year from July 2002 through June 2003 is frequently
written,

FY 2002 - 2003 or sometimes, just

2002 - 2003

is there any way that I can put something like

FY 2002 - 2003

into Cell A1, and then put a formula like...

=A1 + 1

or maybe
=A2 + 365

into Cell B1 and have the value in B1 show as

2003 - 2004

or

FY 2003 - 2004


Can this be done? If it can't be done, perhaps it can be a suggestion for
future versions of Microosft products.

Thanks

Keith

Thank you very much. That was very helpful.
there are three great answers here and I'll try them all.
keith


"Elkar" wrote:

This might work for you, if you're just looking for a way to increment the
displayed value of your Fiscal Years (like for column headers):

In Cell A1:
FY 2002 - 2003

In Cell B1:
="FY " & RIGHT(A1,4) & " - " & RIGHT(A1,4)+1

HTH,
Elkar


"keith" wrote:

Hello,

I frequently use fiscal year representations of years, and would like to be
able to use this in a date field where the year can be incremented by a
formula.
for example, the fiscal year from July 2002 through June 2003 is frequently
written,

FY 2002 - 2003 or sometimes, just

2002 - 2003

is there any way that I can put something like

FY 2002 - 2003

into Cell A1, and then put a formula like...

=A1 + 1

or maybe
=A2 + 365

into Cell B1 and have the value in B1 show as

2003 - 2004

or

FY 2003 - 2004


Can this be done? If it can't be done, perhaps it can be a suggestion for
future versions of Microosft products.

Thanks

Keith

Thank you very much. That was very helpful.
there are three great answers here and I'll try them all.
keith

"vezerid" wrote:

Keith,

there are several ways to tackle this. One way is to put the number
2002 in a cell, say K1. Then let us say you start with your fiscal
years in A3.

="FY "&$K$1+(ROW()-ROW($A$3))&" - "&$K$1+(ROW()-ROW($A$3))+1

Does this help?

Kostis Vezerides

Thank you very much. That was very helpful.
there are three great answers here and I'll try them all.
keith


"CLR" wrote:

=LEFT(A1,4)+1&" - "&RIGHT(A1,4)+1

Vaya con Dios,
Chuck, CABGx3



"keith" wrote:

Hello,

I frequently use fiscal year representations of years, and would like to be
able to use this in a date field where the year can be incremented by a
formula.
for example, the fiscal year from July 2002 through June 2003 is frequently
written,

FY 2002 - 2003 or sometimes, just

2002 - 2003

is there any way that I can put something like

FY 2002 - 2003

into Cell A1, and then put a formula like...

=A1 + 1

or maybe
=A2 + 365

into Cell B1 and have the value in B1 show as

2003 - 2004

or

FY 2003 - 2004


Can this be done? If it can't be done, perhaps it can be a suggestion for
future versions of Microosft products.

Thanks

Keith