Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Dec 10, 2021 11:21 AM
Here’s my entire formula:
WORKDAY_DIFF({Start Date}, {End Date}, ‘2022-01-01,2021-12-25,2021-12-24’)
Works great, but I would like it to only execute if the Start Date and End Date have been filled in. I’m trying to suppress the #ERROR that shows up in the cells otherwise.
Thank you!
Dec 10, 2021 11:29 AM
Welcome to the Airtable community!
IF(
AND({Start Date}, {End Date}),
WORKDAY_DIFF(
{Start Date},
{End Date},
'2022-01-01,2021-12-25,2021-12-24'
)
)