software

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 - 2004Can this be done? If it can't be done, perhaps it can be a suggestion for
future versions of Microosft products.

Thanks

KeithKeith,

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.

=quot;FY quot;amp;$K$1 (ROW()-ROW($A$3))amp;quot; - quot;amp;$K$1 (ROW()-ROW($A$3)) 1

Does this help?

Kostis Vezerides=LEFT(A1,4) 1amp;quot; - quot;amp;RIGHT(A1,4) 1

Vaya con Dios,
Chuck, CABGx3
quot;keithquot; wrote:

gt; Hello,
gt;
gt; I frequently use fiscal year representations of years, and would like to be
gt; able to use this in a date field where the year can be incremented by a
gt; formula.
gt; for example, the fiscal year from July 2002 through June 2003 is frequently
gt; written,
gt;
gt; FY 2002 - 2003 or sometimes, just
gt;
gt; 2002 - 2003
gt;
gt; is there any way that I can put something like
gt;
gt; FY 2002 - 2003
gt;
gt; into Cell A1, and then put a formula like...
gt;
gt; =A1 1
gt;
gt; or maybe
gt; =A2 365
gt;
gt; into Cell B1 and have the value in B1 show as
gt;
gt; 2003 - 2004
gt;
gt; or
gt;
gt; FY 2003 - 2004
gt;
gt;
gt; Can this be done? If it can't be done, perhaps it can be a suggestion for
gt; future versions of Microosft products.
gt;
gt; Thanks
gt;
gt; Keith
gt;
gt;
gt;
gt;

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:
=quot;FY quot; amp; RIGHT(A1,4) amp; quot; - quot; amp; RIGHT(A1,4) 1

HTH,
Elkarquot;keithquot; wrote:

gt; Hello,
gt;
gt; I frequently use fiscal year representations of years, and would like to be
gt; able to use this in a date field where the year can be incremented by a
gt; formula.
gt; for example, the fiscal year from July 2002 through June 2003 is frequently
gt; written,
gt;
gt; FY 2002 - 2003 or sometimes, just
gt;
gt; 2002 - 2003
gt;
gt; is there any way that I can put something like
gt;
gt; FY 2002 - 2003
gt;
gt; into Cell A1, and then put a formula like...
gt;
gt; =A1 1
gt;
gt; or maybe
gt; =A2 365
gt;
gt; into Cell B1 and have the value in B1 show as
gt;
gt; 2003 - 2004
gt;
gt; or
gt;
gt; FY 2003 - 2004
gt;
gt;
gt; Can this be done? If it can't be done, perhaps it can be a suggestion for
gt; future versions of Microosft products.
gt;
gt; Thanks
gt;
gt; Keith
gt;
gt;
gt;
gt;

Thank you very much. That was very helpful.
there are three great answers here and I'll try them all.
keithquot;Elkarquot; wrote:

gt; This might work for you, if you're just looking for a way to increment the
gt; displayed value of your Fiscal Years (like for column headers):
gt;
gt; In Cell A1:
gt; FY 2002 - 2003
gt;
gt; In Cell B1:
gt; =quot;FY quot; amp; RIGHT(A1,4) amp; quot; - quot; amp; RIGHT(A1,4) 1
gt;
gt; HTH,
gt; Elkar
gt;
gt;
gt; quot;keithquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I frequently use fiscal year representations of years, and would like to be
gt; gt; able to use this in a date field where the year can be incremented by a
gt; gt; formula.
gt; gt; for example, the fiscal year from July 2002 through June 2003 is frequently
gt; gt; written,
gt; gt;
gt; gt; FY 2002 - 2003 or sometimes, just
gt; gt;
gt; gt; 2002 - 2003
gt; gt;
gt; gt; is there any way that I can put something like
gt; gt;
gt; gt; FY 2002 - 2003
gt; gt;
gt; gt; into Cell A1, and then put a formula like...
gt; gt;
gt; gt; =A1 1
gt; gt;
gt; gt; or maybe
gt; gt; =A2 365
gt; gt;
gt; gt; into Cell B1 and have the value in B1 show as
gt; gt;
gt; gt; 2003 - 2004
gt; gt;
gt; gt; or
gt; gt;
gt; gt; FY 2003 - 2004
gt; gt;
gt; gt;
gt; gt; Can this be done? If it can't be done, perhaps it can be a suggestion for
gt; gt; future versions of Microosft products.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Keith
gt; gt;
gt; gt;
gt; gt;
gt; gt;

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

quot;vezeridquot; wrote:

gt; Keith,
gt;
gt; there are several ways to tackle this. One way is to put the number
gt; 2002 in a cell, say K1. Then let us say you start with your fiscal
gt; years in A3.
gt;
gt; =quot;FY quot;amp;$K$1 (ROW()-ROW($A$3))amp;quot; - quot;amp;$K$1 (ROW()-ROW($A$3)) 1
gt;
gt; Does this help?
gt;
gt; Kostis Vezerides
gt;
gt;

Thank you very much. That was very helpful.
there are three great answers here and I'll try them all.
keithquot;CLRquot; wrote:

gt; =LEFT(A1,4) 1amp;quot; - quot;amp;RIGHT(A1,4) 1
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;keithquot; wrote:
gt;
gt; gt; Hello,
gt; gt;
gt; gt; I frequently use fiscal year representations of years, and would like to be
gt; gt; able to use this in a date field where the year can be incremented by a
gt; gt; formula.
gt; gt; for example, the fiscal year from July 2002 through June 2003 is frequently
gt; gt; written,
gt; gt;
gt; gt; FY 2002 - 2003 or sometimes, just
gt; gt;
gt; gt; 2002 - 2003
gt; gt;
gt; gt; is there any way that I can put something like
gt; gt;
gt; gt; FY 2002 - 2003
gt; gt;
gt; gt; into Cell A1, and then put a formula like...
gt; gt;
gt; gt; =A1 1
gt; gt;
gt; gt; or maybe
gt; gt; =A2 365
gt; gt;
gt; gt; into Cell B1 and have the value in B1 show as
gt; gt;
gt; gt; 2003 - 2004
gt; gt;
gt; gt; or
gt; gt;
gt; gt; FY 2003 - 2004
gt; gt;
gt; gt;
gt; gt; Can this be done? If it can't be done, perhaps it can be a suggestion for
gt; gt; future versions of Microosft products.
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt; Keith
gt; gt;
gt; gt;
gt; gt;
gt; gt;