=if(and ??
1-4-5 etc. are not excel dates! Use DATE() function to create an excel date
value which can be compared to date in cell O3!
Stefi
"MyKool" wrote:
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
|