Help

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

Execute the formula only when the fields are not empty

Topic Labels: Formulas
552 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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