Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula works but returns #ERROR on blank cells

Topic Labels: Formulas
Solved
Jump to Solution
890 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!!