Comparing dates

  • Thread starter Thread starter Gareth.Evans
  • Start date Start date
G

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
 
Hi Gareth

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

i have 01/02/09 in CJ6, could it have something to do with the way it
is formatted?
 
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.
 
Back
Top