multiple if using a date

[uk747]

currently have:=IF(A1<=TODAY(),"Purchase Date","Error, Date cannot be greater than "&""&TEXT((TODAY()),"dd-mmm-yy"))What I want is if A1 is before 31/12/11 then "Out of Date"if between 31/12/11 to today then "Purchase Date" and finallyif after Today then "Error, Date canot be greater than "&""&TEXT((TODAY()),"dd-mmm-yy"))~Thanks

 

[Robert Mika]

=IF(A1="","",IF(A1<DATE(2011,12,31),"Out of Date",IF(AND(A1>=DATE(2011,12,31),A1<=TODAY()),"Purchase date","Error, Date canot be greater than "&""&TEXT((TODAY()),"dd-mmm-yy"))))

 

[uk747]

=IF(A1="","",IF(A1<DATE(2011,12,31),"Out of Date",IF(AND(A1>=DATE(2011,12,31),A1<=TODAY()),"Purchase date","Error, Date canot be greater than "&""&TEXT((TODAY()),"dd-mmm-yy"))))

says too many arguments for this function, also doesnt need the if a1="","" - If nothing is contained in A1 then it will still say "Purchase Date"

 

[Robert Mika]

=IF(OR(AND(A1 >= DATE(2011,12,31),A1 <= TODAY()),A1=""),"Purchase date",IF(A1 < DATE(2011,12,31),"Out of Date","Error, Date canot be greater than "&""&TEXT((TODAY()),"dd-mmm-yy")))

Remove spaces before ">" and after "<" sign.

 

[uk747]

=IF(OR(AND(A1 >= DATE(2011,12,31),A1 <= TODAY()),A1=""),"Purchase date",IF(A1 < DATE(2011,12,31),"Out of Date","Error, Date canot be greater than "&""&TEXT((TODAY()),"dd-mmm-yy")))Remove spaces before ">" and after "<" sign.

Thanks Robert

 

[Robert Mika]

Thanks Robert

You are welcome.