I have the customers start date in Column A, i.e. 4/1/2007.
In Column B I would like to determine what fiscal year they started in.

For example:
If their start date is between 3/1/08 - 2/28/09, I would like the result of
Column B to be FY08/09.
If their start date is between 3/1/07 - 2/28/08, I would like the result of
Column B to be FY07/08.

Is there a formula for this?

So, what happens if their start date is between 3/1/08 and 2/28/08 ?
You have an overlap on your two ranges.

Pete

On Dec 11, 12:55*pm, sa2960 wrote:
I have the customers start date in Column A, i.e. 4/1/2007.
In Column B I would like to determine what fiscal year they started in.

For example:
If their start date is between 3/1/08 - 2/28/09, I would like the result of
Column B to be FY08/09.
If their start date is between 3/1/07 - 2/28/08, I would like the result of
Column B to be FY07/08.

Is there a formula for this?

I'm not seeing the overlap. Our fiscal year starts March 1 of one year and
ends February 28 of the following year

"Pete_UK" wrote:

So, what happens if their start date is between 3/1/08 and 2/28/08 ?
You have an overlap on your two ranges.

Pete

On Dec 11, 12:55 pm, sa2960 wrote:
I have the customers start date in Column A, i.e. 4/1/2007.
In Column B I would like to determine what fiscal year they started in.

For example:
If their start date is between 3/1/08 - 2/28/09, I would like the result of
Column B to be FY08/09.
If their start date is between 3/1/07 - 2/28/08, I would like the result of
Column B to be FY07/08.

Is there a formula for this?

Assuming real dates in A2 down,
try something like this in say, B2, copied down:
=IF(AND(A2=--"01Mar2008",A2<=--"28Feb2009"),"FY08/09",
IF(AND(A2=--"01Mar2007",A2<=--"28Feb2008"),"FY07/08",""))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"sa2960" wrote:
I'm not seeing the overlap. Our fiscal year starts March 1 of one year and
ends February 28 of the following year