Skip to main content

Date Format in - Day dd-mmm-yyy (Monday 5-Oct-2020)

  • October 4, 2020
  • 3 replies
  • 61 views

Hi everyone, I need create date format as below
(Monday 5-Oct-2020) in excel we easy to to use ddd dd-mmm-yyyy. I can’t find any preset date format as my request format, anybody can show me how to create date format with day.

Thanks

3 replies

Julian_E_Post
Forum|alt.badge.img+13
  • Inspiring
  • 90 replies
  • October 4, 2020

You can find the documentation for Airtable date formatting here

In your case, it would be:

'dddd D-MMM-YYYY'


  • Author
  • New Participant
  • 1 reply
  • October 4, 2020

You can find the documentation for Airtable date formatting here

In your case, it would be:

'dddd D-MMM-YYYY'


Hi Julian,

Where to paste date format? ‘dddd D-MMM-YYYY’ under the formula?


Julian_E_Post
Forum|alt.badge.img+13
  • Inspiring
  • 90 replies
  • October 4, 2020

Say that you have your current date that you’d like to format in a column called “Original Date”. Create a new column, “Formatted Date” (or whatever you’d like to call it), and use this formula:

DATETIME_FORMAT({Original Date},'dddd D-MMM-YYYY')

Currently, there isn’t a way to make a custom format in a column that has Airtable’s “Date” field type- there, you’re limited to a dropdown of a couple options when you create the field type. In any column where you’re using a formula, however, you can use this.