Thread: Date trouble
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carl Gross Carl Gross is offline
external usenet poster
 
Posts: 1
Default 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?