I have this formula

WORKDAY({Release Date},-{weeks out in #days})

it returns the date that I need but if there is a cell with Release Date empty, it returns #ERROR.

I have tried this formula

IF( AND( {Release Date}, {weeks out in #days} ), DATETIME_DIFF({weeks out in #days},{Release Date},‘date’), BLANK())

it removes the #ERROR on the cells that it should, but it puts #ERROR in all of the date fields, I lose the dates that I need.

I have tried this formula

WORKDAY({Release Date},-{weeks out in #days}, BLANK())

this one puts #ERROR in all cells.

what I need:

the first formula that returns dates, but if the {Release Date} cell is empty, I want to see a blank rather than #ERROR.