Skip to main content

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

  • October 4, 2020
  • 3 replies
  • 61 views
S

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
    • Julian_E_Post
    • 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'

    S
    • SALES_ASIA
    • 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
    • Julian_E_Post
    • 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.


    Terms & ConditionsAccessibility statement