View Single Post
  #2   Report Post  
bj
 
Posts: n/a
Default

it returns a 0 for me

"John Brown" wrote:

Something's screwy. Two dates in different cells:

a1: 1/1/2003
b1: 10/29/2001

=a1-b1: 429
=b1-a1: -429
=if(a1<b1,1,0) 1

How can the last formula return a 1????