Problems with comparing dates

[aijihz]

hi all,

My problem is :

I have 2 dates:

Date 1: 30/11/1999
Date 2: 15/12/1999

When i compare it as below:

if (Date2>Date1,"true","false")

-->The output is "false",but in actual fact Date2 is later than Date1.What is the problem?

Thanks

[Barrie Davidson]

Make sure that Excel recognizes your values as dates. Try
=ISNUMBER(Date 1)
to see. If the formula returns FALSE, then Date 1 is a string (that's my guess).

Hope this helps,

[aijihz]

thanks a lot :D....