Comparing dates

[Gareth.Evans]

Hi all thankyou fro you help, i am trying to compare to dates and say
weather one is higher then the other. my formulas below work on one
worksheet but not another, and i am at a complete loss as to why?

A1 - 13/03/2009 as date
A2 - calculates 21/03/2009 by DATE(YEAR(CJ6),MONTH(CJ6)+1,DAY(CJ6)+20)
A3 - calculates "No" by IF(A1<A2,"Yes","No")

Clearly A1 is smaller then A2 so A3 should be equal to "Yes" and not
"No"

This is completely doing my head in, hope you can help

 

[Roger Govier]

Hi Gareth

Works fine for me.
I assume you have 01 Feb 2009 in cell CJ6

 

[Gareth.Evans]

Hi Gareth

Works fine for me.
I assume you have 01 Feb 2009 in cell CJ6

i have 01/02/09 in CJ6, could it have something to do with the way it
is formatted?

 

[Roger Govier]

Hi
No, the formatting should make no difference.
I merely wrote the date in that way so there could be no confusion with
English or American date formats.
Providing your formula in cell A2 does return a date, and the Year is 2009
(09), then it should work.
As, I said, it works fine for me.