Fiscal Year in date field

K

keith

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
 
V

vezerid

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
 
E

Elkar

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
 
K

keith

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

keith

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

keith

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