Microsoft Excel Training Videos

Formatting dates in Excel




Formatting dates in Excel has to be done in a specific way otherwise you will not be able to use the dates for calculations. Excel has interesting data formats and the most common is mm/dd/yyyy where you enter the month in two digits, the day in two digits and the the year in four digits like 09/01/2009 for '1st September 2009'.

How to format the data type dates in Excel

  • Select the cells on the Excel worksheet that you wish to format and enter dates
  • Click on Format in the menu bar and select 'Cells...'
  • In the Format Cells dialog box, select number and then date from the Category
  • Under Type select the format that suits your work
  • Under Locale (Location) keep the default English (United States)
  • Under Alignment select how you would like your data to be aligned in the Excel cells
  • In the Font section define the font face, size, colour, etc of your choice and finally click on OK to complete the process as shown in the Excel training video

More about dates in Microsoft Excel

Formatting dates in Excel