5 must-know date formulas in Airtable

Recurring dates and 4 other formulas that will help you boost your Airtable workflows.

Photo by Jeswin Thomas from Pexels

Hardly any base in Airtable goes far without using the date field. Using the formula field in combination with dates will open a whole new area of improvement and automation for your projects. Creating automated week number columns, sorting your financial entries by a Quarter field, calculating remaining days (or even working days only) until a recurring deadline, are just a few examples of how to improve your workflow with date formulas. Read on.

Number of the day, month or year

This is formula is fairly straightforward. Select a day, a month or a year function and insert your

DAY(Date)
MONTH(Date)
YEAR(Date)

DAY() and MONTH() formulas

The result will be a number, which can be used in further formulas as described further below.

Weeks, Months, and Quarters

Here are some fewer know applications of DATETIME_FORMAT() formula. One of the applications is formating the date to display the ISO number of the week:

DATETIME_FORMAT(Date,"W")