Airtable Date Formulas

Airtable – Formula to calculate the number of workdays between two date fields (columns)

Are you setting up Airtable templates with formulas for your team? Add this formula in one of our expert-created Airtable templates.

See our Airtable templates

Airtable Formula: Calculate the number of workdays between two date fields (columns)

The formula is:

WORKDAY_DIFF(startDate, endDate)

↑ Copy and paste into Airtable then switch out the bold property name/s in the formula to match the name of the property name/s you’re using.

 

How to create a date formula in Airtable

The steps to creating a date formula in Airtable are:

  1. Create an Airtable base
  2. Ensure your board is set up in Grid view
  3. Add a column by clicking on the + icon to the right of the existing column name
  4. Select Date and then Create field
  5. You can choose to add an extra date column to set up a formula between the two columns or use a single column
  6. Add another column and scroll down to select Formula
  7. Add a Field Name
  8. Add your formula in the simple editor box and then click Create field

 

How to edit a date formula in Airtable

The steps to editing a date formula in Airtable are:

  1. Hover over the column name and click Edit field
  2. Add your new formula in the box and then click Save