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?