First things first, open up the Airtable base where you want to figure out the working days. Make sure you've got a table with a start date and an end date.

If you don't already have them, add these two fields:

• Start Date: This should be a Date field marking the beginning of the period.
• End Date: Another Date field, but this one marks the end of the period.

Now, add a new field to your table and call it something like Working Days. Set the field type to “Formula”.

In the formula field, you’ll want to calculate the total number of days between the Start Date and End Date. Use this formula:

DATETIME_DIFF({End Date}, {Start Date}, 'days')

This will give you the total number of days, but heads up—it includes weekends.

To exclude weekends, tweak the formula in the Working Days field. Use this adjusted formula:

IF(
    AND({Start Date}, {End Date}),
    IF(
        WEEKDAY({Start Date}) <= WEEKDAY({End Date}),
        INT((DATETIME_DIFF({End Date}, {Start Date}, 'days') / 7) * 5 + (MIN(WEEKDAY({End Date}) + 1, 6) - MAX(WEEKDAY({Start Date}), 1))),
        INT((DATETIME_DIFF({End Date}, {Start Date}, 'days') / 7) * 5 + (6 - WEEKDAY({Start Date})) + MIN(WEEKDAY({End Date}) + 1, 5))
    ),
    BLANK()
)

This formula takes into account the days of the week for both start and end dates, calculates the number of full weeks, and then adjusts for any partial weeks at the beginning or end of the period.

Save the formula to apply it to the new Working Days field. Airtable will now calculate the working days between the Start Date and End Date for each record, skipping weekends.

Double-check the results for a few records to make sure the formula is correctly calculating the working days. Adjust the formula if needed.

And there you have it! This setup will dynamically calculate the working days while excluding weekends in Airtable.