Help

Formula works but returns #ERROR on blank cells

Topic Labels: Formulas
Solved
Jump to Solution
799 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Kitty_Matz
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

1 Solution

Accepted Solutions
Kitty_Matz
5 - Automation Enthusiast
5 - Automation Enthusiast

I got it from other community chats:
IF(
{Release Date},
WORKDAY({Release Date},-{weeks out in #days})
)

thank you Jeremy Oglesby!!

See Solution in Thread

1 Reply 1
Kitty_Matz
5 - Automation Enthusiast
5 - Automation Enthusiast

I got it from other community chats:
IF(
{Release Date},
WORKDAY({Release Date},-{weeks out in #days})
)

thank you Jeremy Oglesby!!