=IF(AND(O3=DATE(2005,4,1),O3<=DATE(2005,6,30)),"Q 1",IF(AND(O3=DATE(2005,7,
1),O3<=DATE(2005,9,30)),"Q2",IF(AND(O3=DATE(2005, 10,1),O3<=DATE(2005,12,31)
),"Q3",IF(AND(O3=DATE(2006,1,1),O3<=DATE(2006,3,3 1)),"Q1","Not this Q"))))


Mangesh




"MyKool" wrote in message
...
Hi can you please help ?

I am trying to insert a formula that works out if a purchase was done in
Qtr1, Qtr2, Qtr3 or Qtr4 of this financial year..

I have a column with dates of purchase in and am trying the following
formula but to no success:

=IF(AND(O3<=1-4-5,O3=31-7-5),"Qtr1",IF(AND(O3<=1-8-5,O3=30-9-5),"Qtr2",IF(
AND(O3<=1-10-5,O3=31-12-5),"Qtr3",IF(AND(O3<=1-1-6,O3=31-3-6),"Qtr4","Not
this fiscal year"))))
Can you please help me...

Many thanks