How to Only Display the Year for a Date in Excel 2013

There are a lot of different options when it comes to formatting a date in Excel, and the variety of reasons that you might be storing dates in a spreadsheet will dictate the format that you select.

But if the only important part of a date for your purposes is the year, then you might be looking for a way to display your date as just the year.

Our guide below will show you how to apply this formatting to your date to achieve your desired result.

You can read our guide on how to see formatting in Excel if you would like to check the current format that is applied to some of the cells in your worksheet.

How to Format for “Year Only” in Excel 2013

The steps in this article will assume that you have a date in a cell, or group of cells, and that you only want to display the year from that date. The full date will still be stored as the value in the cell, but only the year will be shown.

Here is how to only display the year of a date in Excel 2013 –

  1. Open the spreadsheet in Excel 2013.
  2. Select the cell(s) containing the date(s) that you want to format as year-only.
  3. Right-click a selected cell, then click the Format Cells option.
  4. Click Custom from the options in the column at the left side of the window.
  5. Enter yyy in the Type field, then click the OK button.

You can see these steps below, but with pictures –

Step 1: Open the spreadsheet in Excel 2013.

Step 2: Select the cell, or group of cells, containing the dates that you wish to format to only show the year.

select the cell with the date

Step 3: Right-click one of the selected cells, then click the Format Cells option.

click format cells

Step 4: Click Custom in the Category column at the left side of the window.

select custom formatting

Step 5: Enter yyy into the Type field at the center of the window, then click the OK button to apply your changes.

how to format as date only in excel 2013

Note that you can also use the formula =YEAR(XX) where XX is the cell containing the date whose year you wish to display.

Does your worksheet have a lot of formatting that you need to remove, and you would prefer to simply remove all of it at once? Learn how to clear all cell formatting in Excel with just a few short steps.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy