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 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|
|6||Friday, 02 November 2012||dddd, dd mmmm yyyy|
|7||Fri, 2/11/2012||ddd, d/mm/yyyy|
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.
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.
|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)|