
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 09, 2022 12:17 PM
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.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 09, 2022 12:56 PM
I got it from other community chats:
IF(
{Release Date},
WORKDAY({Release Date},-{weeks out in #days})
)
thank you Jeremy Oglesby!!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 09, 2022 12:56 PM
I got it from other community chats:
IF(
{Release Date},
WORKDAY({Release Date},-{weeks out in #days})
)
thank you Jeremy Oglesby!!
