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!
+29Welcome 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'
)
)
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.