IF Formula to calculate whether date has passed
 

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

IF Formula to calculate whether date has passed
 

=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.

IF Formula to calculate whether date has passed
 

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.

IF Formula to calculate whether date has passed
 

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.

IF Formula to calculate whether date has passed
 

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.