Tutorial 11: Working with Date Formats

In any cell in an Excel worksheet, you can type a date. However, after you have entered a date it may display in a format that is different to what you want.

Excel Video Tutorial 11: Working with Date Formats in ExcelExcel allows you to customise the format of any date to any format that your would prefer. For example, it is often more than useful to be able to include the day of the week (see sample 6 in the table below).

The Video Tutorial will show you how to invoke or change the format of a date in a worksheet cell.

For further explanation, here are some examples for the date of 2 November 2012:

Sample Example Date Custom Format Used
1 02 November 2012 dd mmmm yyyy
2 2 November 2012 d mmmm yyyy
3 2 Nov 2012 d mmm yyyy
4 2-Nov-12 d-mmm-yy
5 02/11/12 dd/mm/yy
6 Friday, 02 November 2012 dddd, dd mmmm yyyy
7 Fri, 2/11/2012 ddd, d/mm/yyyy
8 11/2/12 mm/d/yy

Notice in the above table the use of separators i.e. the slash " / " or the dash " - " You can choose which separators you prefer, or none at all.

Custom Date Formats

In the video tutorial, you are shown how to create custom date formats using combinations. The basic ingredients are "d" for day, "m" for month and "y" for year. Depending on the number of d's, m's or y's you type into the custom date format box, you will get a different format. Watch the video tutorial.

Date Code Description
m Month as a number without leading zeros (1-12)
mm Month as a number with leading zeros (01-12)
mmm Month as an abbreviation (Jan - Dec)
mmmm Unabbreviated Month (January - December)
d Day without leading zeros (1-31)
dd Day with leading zeros (01-31)
ddd Week day as an abbreviation (Sun - Sat)
dddd Unabbreviated week day (Sunday - Saturday)
yy Year as a two-digit number (for example, 96)
yyyy Year as a four-digit number (for example, 1996)

 

 

Event Operations Manual
Software for Club Treasurers