Airtable "Pretty Date" formulas (16 styles)


If you're using Airtable to manage your client's collection data, use these formulas to update the date to display with a 'pretty date' style. To use these formulas, have your client add the date using a Date Picker column type. Add the formula column from this spreadsheet and reference their date column inside of the curly braces in the formula. (Email me with a link to the base if you get stuck on that step.) The formulas then turn your plain date into a 'pretty date' using the specified formatting.


Available formulas create these formats:

  • January 1, 2022
  • Jan 1, 2022
  • 01/25/2022
  • 01-25-2022
  • 1.25.2022
  • 01/25/22
  • Wednesday, January 5, 2022
  • Wednesday, January 5th, 2022
  • January 5th, 2022
  • 05 Jan 2022
  • 05 January 2022
  • 2022-01-05
  • 5 Jan 2022
  • January 5th 2022
  • Wednesday the 5th
  • The 5th of January


If you need another date type, send me an email and I'll add it to the spreadsheet (IF it's possible). This is just for the date and not for time.