Date trouble

C

Carl Gross

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?
 
S

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

[email protected]
[email protected] with @tiscali.co.uk
 
T

Teethless mama

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


Sandy Mann said:
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

[email protected]
[email protected] with @tiscali.co.uk
Click to expand...
 
Top