How to Show Multiple Date Fields in One Airtable Calendar View

You have a Start Date and a Due Date on the same record, and you want both dates to appear on one calendar. Airtable can do this on paid plans by plotting both fields as separate calendar events.

I’ll use those two fields throughout this example. The same setup works for any other date fields in the table.

Add both date fields to the calendar

From the table that contains your records, add a new Calendar view. When Airtable asks which date fields to use, choose Start Date as the first date field and add Due Date as an additional date field.

Do not choose Due Date as the end date if you want two separate events. Choosing it as the end date creates one date range from Start Date to Due Date.

To add or change the fields after creating the view, click the calendar icon in the view bar. Select the date fields you want to plot, then give them labels such as Start and Due so people can tell them apart.

Both dates now appear on the same calendar. A record with a Start Date of January 5 and a Due Date of January 20 will show one event on January 5 and another on January 20.

Paid plans let you plot up to 20 date fields or date ranges on one calendar view. Each field can have its own label.

Colour the dates by field

You do not need to create a separate Type field just to tell Start Date and Due Date apart. Airtable can colour each event based on the date field that created it.

In the calendar view, click Color and choose the option for coloring events by their date fields. Start Date and Due Date will then use different colors on the calendar.

You can still colour by a single select field if you want to show something else, such as Project status or Event type. For this example, coloring by date field is the more useful option because it tells you whether an event is a start date or a due date.

What you can do on the Free plan

The Free plan supports calendar views, but it does not support plotting multiple date fields or date ranges on the same calendar.

If you need both dates on a Free-plan calendar, create one record for each date in a separate events table. Add a Date field and a Type field with options such as Start and Due. Link each event back to the original project if you still need to see both dates under one project.

This gives you one calendar event per record, so a project with a Start Date and Due Date appears as two linked event records.

If the dates are in different tables

Airtable calendar views use records from one table. They cannot combine records from a Tasks table and an Events table in the same native calendar view.

If you need one calendar for several tables, keep the source tables separate and create a central calendar table, or move similar records into one table with a field such as Type. For the central-calendar approach, see how to keep one central Airtable calendar updated from multiple tables.