Airtable – Formula for adding 8 hours to a specific date field (column)

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: Adding 8 hours to a specific date field (column)

The formula is:

DATEADD([Specific Date], 8, 'hours')

↑ 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