J
Janelle Lister
What formula can I use that will insert "Yes" if the date in cell A1 is after
the date in cell A2, for example.
the date in cell A2, for example.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave F
=IF(A1>A2,"Yes","No")
Dave
Dave
J
Janelle Lister
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.
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.
D
Dave F
Formula is calculating correctly. 1/1/2007 is after 10/18/2006.
Dave
Dave
H
hot dogs
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.
10/18/2006 therefore A1 is greter than (>) A2. So 'Yes' is returned.