Multiple IF - Date within a range

[TRS]

Hi all,

I want to check if a date is between two specific dates and if it is also after a third date.

a b c d
1 DATE TO CHECK APPROVAL START DATE END DATE
2 25-Feb-2011 20-Feb-2011 20-Feb-2011 19-May-2011

I tried

=IF(AND($A2>=B$2,$A2>=$C2,$A2<=D2),"ok","not ok")

but it does not work! Did I make any mistake?
For example in this case I got "not ok" even if it should be "ok".

Can it be related to the cell format??

Thanks!!!

[NBVC]

I get "ok". Are you sure the dates are entered as Dates and not as text.

If you select each date you should see the date in the formula bar formatted as: m/d/yyyy (e.g. 2/25/2011).

If not, then enter a 0 into any blank cell and copy it, then select the dates and go to Edit|Paste Special and select Add.

Then format the cells as Date.

[martindwilson]

gives ok for me check all cells contain real dates and not text

[TRS]

indeed it was the text formatting!
I tried to make text to date in all the ways I know but it did not work!
I had to write manually each date!

Anyway thanks for your help. at least the formula was correct