Try something like this:
=IF(CELL("format",A1)="D4",A1,IF(CELL("format",B1) ="D4",B1,"none of A1 and
B1 is a date!"))

But first have a look at CELL function and choose a date format which
returns one of D1-D5 codes, and adjust formula to your choice!

Regards,
Stefi

€žhjm€� ezt Ã*rta:

Can the following be done?
If there is a date in column A, then return A otherwise if it is blank or
N/A look at column B & if there is a date there return col B.

Hope someone can help.

Thanks!