Comparing dates
Hi Gareth
Works fine for me.
I assume you have 01 Feb 2009 in cell CJ6
--
Regards
Roger Govier
"Gareth.Evans" wrote in message
...
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
|