On Mar 25, 7:05*pm, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
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.

--
Regards
Roger Govier

"Gareth.Evans" wrote in message

...

On Mar 25, 6:48 pm, "Roger Govier"
<roger@technology4unospamdotcodotuk wrote:
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

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

When i evaluate the formula, one date returns 17/03/2009 and the other
39893 (excels interpretation).
On the worksheet that works they both return number strings ie
39892<39893.
How do i get the date to evaluate to a number?