If Cell is not blank, equal date from different cell

Jennifer Rockwell

I need the minds of the collective community!

I am trying to create a formula that states:

If "BCR Initial Approved Date" is not blank, then use date from "Estimated SFS date" or If "BCR Initial Approved Date" is Blank, leave blank.

Attached is my attempt at creating the formula but it give me an Incorrect Argument set.

Appreciate any help you can provide.

Jennifer

Mark Cronk

Hi @Jennifer Rockwell ,

Try:

IF(ISDATE([BCR initial approve date]@row), [Estimated SFS date]@row, "")

Mark