Execute the formula only when the fields are not empty

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!

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'
    )
)
2 Likes

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.