Skip to main content
  • Login
Cart
Exceljet logo Exceljet
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
Cart
  • Login
  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles
  • Login

You are here

Home › Videos › How to create a custom date format

How to create a custom date format

Transcript 

In this lesson, we'll look at how to create a custom date format. Excel provides a good selection of date codes that can be used to assemble a wide variety of custom date formats.

Let's take a look.

Let's look first at the Date code reference table. This table shows the date codes available for custom date formats. There are several codes each for days, months, and years, including abbreviated and non-abbreviated forms, and the option to add leading zeros to day and month numbers.

Now let's look at the table we need to format. In the left column, we have a list of dates. The other columns show the custom formats we need to create. Let's start by copying the dates across the entire table.

When building custom date formats, it's often easier to apply a date format that is close to what you want to create, as a start. For column C, the existing format already has all of the components we need. We just need to access the Format Cells dialog, click Custom, and rearrange the codes.

Note that Excel displays a live preview as you create the custom format.

We repeat the process for column D. The Long Date format is close to what we want, so let's start with that. Then we click Custom, and modify.

To abbreviate the day of week, we just use three "d's" instead of four. We do the same thing for month—three "m's" will give us a three-letter month abbreviation.

Since the format in column E is simple, let's just build it from scratch. Looking at our reference table, we can see that we need a code for an abbreviated month (three m's) and a code for the day with a leading zero, which is two d's.

In the Format Cells dialog, we select Custom, then just enter: "mmm space dd" and click OK.

Master Excel with practice. Download this worksheet (and dozens more) in our Core Excel course. Learn by doing.

Dave Bruns Profile Picture

Author

Dave Bruns

Hi - I'm Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Microsoft Most Valuable Professional Award  

Exceljet Training

  • Excel 101
  • Excel Fundamentals
  • Conditional Formatting
  • Essential Formulas
  • Advanced Formulas
  • Pivot Tables
  • Excel Tables
  • Excel Shortcuts
  • Excel Charts
  • Course Bundles
I work for a large corporation where I am the Excel Guru and I think my skill level is advanced. This makes it difficult when I do run into issues because I have no one to go to for advice. Luckily you have been there to help me solve an issue via your site. I have been following you for years. Much of what I know comes from you and a few others. I would say I have learned the most from you. Much appreciation for the work you and wife do.
John
More Testimonials

Get Training

Quick, clean, and to the point training

Learn Excel with high quality video training. Our videos are quick, clean, and to the point, so you can learn Excel in less time, and easily review key topics when needed. Each video comes with its own practice worksheet.

View Paid Training & Bundles
Excel foundational video course
Excel Pivot Table video training course
Excel formulas and functions video training course
Excel Charts video training course
Video training for Excel Tables
Dynamic Array Formulas
Exceljet logo Exceljet
Quick, clean, and to the point

Resources

  • Training
  • Videos
  • Functions
  • Formulas
  • Shortcuts
  • Articles

About Us

  • About
  • Testimonials
  • Topics
  • Contact
  • Donate

Newsletter Sign-up

Work faster in Excel. Join more than 100,000 people who get weekly tips from us.
© 2012-2025 Exceljet. Terms of use
  • Visit our Twitter page