J
JayDee
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.
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.