Skip to main content

Hi all, 

I am copying over historical data into a new Airtable system and I am using the following formula for calculating the number of days taken to complete a task

 

IF(
  OR({Date Completed}, {Date Completed Override}),
  WORKDAY_DIFF(
    IF({Start Date Actual Override}, {Start Date Actual Override}, {Start Date Actual}),
    IF({Date Completed Override}, {Date Completed Override}, {Date Completed})
  ),
  BLANK()
)

It works just as intended, it counts the number of workdays to complete a task, using the default field unless an override date is being used.

However, there are one or two results that are just way off. As an example, one record has the following values:

Start Date Actual: blank
Start Date Actual Override: 1/3/2025
Date Completed: blank
Date Completed Override: 23/4/2025
Completed Task Duration: 474831

What is baffling me is that there is another record with exactly the same dates that is correctly returning a value of 15.

The default fields are auto generated via a formula, and the override dates just use the date field to manually enter the date when needed.

Thanks for your help

Hm that’s interesting!  Just tried to recreate that but wasn’t able to figure anything

Any chance you could provide screenshots or even better, a link to a duplicated copy of your base with some example data in it? 

Yes, please do send over screenshots/duplicate base! Logic of the formula looks ok at first sight. 

Reply


Terms & Conditions