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.
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.
For column C, the existing format already has all of the components we need.
We just need to pull up the Format Cells dialog, click Custom, and rearrange the codes.
Note that Excel displays a live preview as you create the custom format.
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 monththree “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.
