5 Custom Date Formats I Always Use and You Should Too

How to use these Custom Date Formats

To all the formats which I have mentioned above you need to follow below steps.

  1. Select the cell where you want to apply the format.
  2. Now, press right click and select "Format Cell". Or, you can also use a keyboard shortcut Ctrl + 1 to open format cell options.
  3. After that select custom and enter the format in the input bar and click OK.
add custom format to format cell option

#1 - Day Name

This one is my favorite. If you are working on some dates where you want to get the day name only, this custom date format can help you.

“It’s” dddd

day name custom date format in excel

And, if you want to get the day name in short form, you can use below format.

“It’s” ddd

#2 - Day Number

Just like the day name if you want to get the day number you can use this custom format.

“Day” d

a day number with custom date format

#3 - Month Name

This custom date format will help you to get month name for your date value. And, you can also add some custom text as per your requirement.

“Current Month is:” mmmm

a full month name with custom format

#4 - Date with a Day Name

This format gives help you a date with a day name in the end.

dd-mmm-yyyy (ddd)

a simple date with day name with custom format

#5 - Long Textual Date

And, if you want a long textual date you can do this by using this below format.

“Today is Day” d”, Month” m “& Year” yyyy.

a long textual date with custom format

Now tell me one thing. Do you have any format which you use? Share with me in the comment section.

Must Learn Excel Tutorials

Content Protection by DMCA.com


  1. Christopher Dao 2 Oct, 18 at 7:42 pm - Reply

    How could we add a letter at the end ie.: 02/17/2018-S

  2. fbthfl 22 Sep, 17 at 12:37 am - Reply

    Consider explicit, int’l date formats
    21/009/2017 dd/”0″MM/yyyy
    009.21.2017 “0”MM.dd.yyyy
    2017-009-21 yyyy-“0″mm-dd

    Info @ https://goo.gl/cbKPje

  3. Nishan Rashed 10 Feb, 17 at 8:17 am - Reply

    Hey Puneet,
    exactly where are you writing this custom format?

    • fbthfl 22 Sep, 17 at 12:43 am - Reply

      In MS Excel where you select your Number Formats, there is a CUSTOM option at the end of the list which also includes Currency, Date, General and more. Select CUSTOM, then in the TYPE field, use the options above, such as dd/”0″MM/yyyy for 21/009/2017. Hope this helps.
      #yyyy0MMdd Info @ https://goo.gl/cbKPje #1World1Date1Day

      • Plastic Cup 24 Sep, 17 at 4:01 pm - Reply

        I’m liking this idea and will start using it. There will be push back but it will eventually catch on.

        • fbthfl 24 Sep, 17 at 5:25 pm - Reply

          Pushback?! Indeed. So please use it where you can, chat it up, Spread the word!

  4. ratanak 23 Feb, 16 at 6:28 am - Reply

    great job,puneet

    • Puneet Gogia 23 Feb, 16 at 7:18 am - Reply


Leave A Comment