touche !

--
Biff
Microsoft Excel MVP


"John C" <johnc@stateofdenial wrote in message
...
Nice of you to notice, of course, you didn't notice that cells A1 and A2
are
pulling in dates from another sheet, and therefore, other values do not
populate in cells A1 & A2.
--
John C


"Teethless mama" wrote:

Your formula will fail if there are text value example: a1=a, a2=b

=IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE",""))


"John C" wrote:


=IF(OR(A1="",A2=""),"",IF(A2A1,"PAST DUE",""))

Hope that helps.
--
John C


"JayDee" wrote:

In A1, I have a date linked from another file worksheet. I used the
If (is
blank) formula so no data appears unless there is a date to link from
the
other worksheet.

In A2, I also have a date linked from another file worksheet. I also
used
the If (is blank) formula so no data appears unless there is a date
to link
from the other file worksheet.

I am trying to write a formula for Cell A3 that will return a given
phrase
(i.e. past due) if the date in cell A2 is greater than the date A1.
AND,
return a blank cell for A3 if there are no dates in cells A1 or A2.