Pulling a date based on if a field is blank

Michael.Damron

I have 2 columns of data, [Date1] and [Date2].

[Date2] is sometimes blank.

I want to create a new column of data that shows [Date2] if not blank, and [Date1] if blank.

Can someone help me create the correct formula for this? I guessed that I would need an IF formula with a ISBLANK within, but I'm having trouble with how to assign my results.

Paul H

Try

=IF(ISDATE([Date 2]@row), [Date 2]@row, [Date 1]@row)

Paul H

Try

=IF(ISDATE([Date 2]@row), [Date 2]@row, [Date 1]@row)

Michael.Damron

I was so close to having it correct, that worked perfectly. Thank you!