Date trouble

[Guest]

cell A2 has the date 3/9/2007

When I test the following formula - =(A2+45)>=4/27/2007 I get True, but I
should get false.

AlSO, when I put in =4/23/2007<4/27/2007 I get false. Both expressions
should evaluate to true.

What is going on?

 

[Sandy Mann]

Carl,

If you highlight the 4/27/2007 of your formula and press F9 you will see
that it equates to 0.0000738157190573733 which is 4 divided by 27 divided by
2007.

Try enclosing your date in quotes

=(A2+45)>="4/27/2007"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

(A2+45)>=--"4/27/2007"

Carl,

If you highlight the 4/27/2007 of your formula and press F9 you will see
that it equates to 0.0000738157190573733 which is 4 divided by 27 divided by
2007.

Try enclosing your date in quotes

=(A2+45)>="4/27/2007"

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[Guest]

how bout this

=(A2+45)>=value("4/27/2007")

Esteban

 

[Sandy Mann]

(A2+45)>=--"4/27/2007"

You're quite correct. I coiuld have sworn that I got a TRUE as well as a
FALSE when I tetsed it.

Thanks for the catch.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk