Skip to main content

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'

    )

)

Reply


Terms & Conditions