Date trouble
 

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?

Date trouble
 

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


with @tiscali.co.uk


"Carl Gross" wrote in message
...
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?

Date trouble
 

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


"Sandy Mann" wrote:

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


with @tiscali.co.uk


"Carl Gross" wrote in message
...
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?

Date trouble
 

how bout this

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

Esteban

"Teethless mama" wrote:

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


"Sandy Mann" wrote:

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


with @tiscali.co.uk


"Carl Gross" wrote in message
...
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?

Date trouble
 

"Teethless mama" wrote in message
...
(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


with @tiscali.co.uk