One function away!
You're welcome.
"Andy" wrote:
Thanks So Much!
"JMB" wrote:
perhaps
=IF(ISNUMBER(AJ7),AJ7,AK7)
"Andy" wrote:
I need a function that will scan two cells with potential dates in them. If
the first cell (AJ7) does not have a date in it, I need it to reference the
cell next to it (AK7) for the projected close date...
Any ideas?
|