I am trying to write an IF statement to tell me which fiscal year the
transcation occurred in. My formula is:

=IF((AND(I2="11/1/2004",I2<="10/31/2005")),"FY
2005",(IF((AND(I2="11/1/2005",I2<="10/31/2006")),"FY 2006", "ERROR")))

I2 is the cell which contains the date of the transcation.

Dates between 11/1/2004 and 10/31/2005 are in FY 2005 and dates between
11/1/2005 adn 10/31/2006 are in FY 2006.

I appreciate any help.