Help

Execute the formula only when the fields are not empty

Topic Labels: Formulas
940 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Gene_Ellis
4 - Data Explorer
4 - Data Explorer

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!

1 Reply 1

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