One function away!

[Andy]

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?

 

[JMB]

perhaps

=IF(ISNUMBER(AJ7),AJ7,AK7)

 

[Andy]

Thanks So Much!

perhaps

=IF(ISNUMBER(AJ7),AJ7,AK7)

 

[JMB]

You're welcome.

Thanks So Much!