Use the YEAR function to extract the year part of a date - Date and Time Functions - Microsoft Excel

Use the YEAR function to extract the year part of a date using Microsoft Excel

As shown in Figure, column A of a worksheet contains a list of dates formatted in different ways. To determine the year corresponding to a date, use the YEAR function. This function returns the year as an integer in the range 1900 to 9999. If the year is not specified, as in cell A9, the year is assumed to be the current year.

To extract the year as part of a date:

1. In cells A2:A10, generate a list of dates using different formats.
2. Select cells B2:B10 and type the following formula:
=YEAR(A2).
3. Press <-Ctrl+Enter->.

Use the YEAR function to extract the year part of a date

Watch the Video Tutorial - https://www.youtube.com/watch?v=IsJFpZD4yu0