IF Function with conditions

[EstherJ]

I need a formula which will look at the following conditions and if it agrees
put the text "OK" in a cell, if it does not match the "Not OK". Anything I
have tried doesn't work!

If cell A1 is greater that 28/11/2004
If cell A1 less than 31/12/2005
If cell B1 is greater than 28/11/2004

Thank you for your help.

Esther

[JulieD]

Hi Esther

one way
=IF(AND(A1>DATEVALUE("28/11/04"),A1<DATEVALUE("31/12/05"),B1>DATEVALUE("28/11/04")),"ok","not
ok")

Cheers
JulieD

"EstherJ" <EstherJ@discussions.microsoft.com> wrote in message
news:EA151E9B-6907-48B4-A712-BA186437BAEE@microsoft.com...
>I need a formula which will look at the following conditions and if it
>agrees
> put the text "OK" in a cell, if it does not match the "Not OK". Anything
> I
> have tried doesn't work!
>
> If cell A1 is greater that 28/11/2004
> If cell A1 less than 31/12/2005
> If cell B1 is greater than 28/11/2004
>
> Thank you for your help.
>
> Esther