Excel considers the later date to be larger, i.e. A1 = 1/1/2007, A2 =
10/18/2006 therefore A1 is greter than () A2. So 'Yes' is returned.

"Dave F" wrote:

Formula is calculating correctly. 1/1/2007 is after 10/18/2006.

Dave
--
Brevity is the soul of wit.


"Janelle Lister" wrote:

Thank you, but I'm afraid I'm still having trouble. The formula is returning
an incorrect response. Does it change the IF formula if cell A2 also
contains a formula? Cell A1 has a value of January 1, 2007. Cell A2 is the
formula =TODAY().
Today is October 18, 2006 and the formula below returns the result Yes.


"Dave F" wrote:

=IF(A1A2,"Yes","No")

Dave
--
Brevity is the soul of wit.


"Janelle Lister" wrote:

What formula can I use that will insert "Yes" if the date in cell A1 is after
the date in cell A2, for example.