Excel Tutorial – YEAR

The YEAR function in Microsoft Excel is a function that extracts the year from a date. This can be useful if you want to perform calculations based on the year or if you want to extract specific years from a list of dates.

To use the YEAR function, follow these steps:

1. Open your Excel workbook and navigate to the cell where you want to apply the YEAR function.
2. Type “=YEAR(” into the cell, followed by the cell reference or date that you want to extract the year from. For example, if you want to extract the year from the date in cell A1, you would type “=YEAR(A1)”.
3. Press the “Enter” key to complete the formula. The cell will now display the year.

Here’s an example of how you can use the YEAR function in a formula:

=IF(YEAR(A1)=2022, “This year”, “Not this year”)

In this example, the YEAR function is used to extract the year from the date in cell A1. The IF function then checks if the year is 2022 and displays “This year” if it is, or “Not this year” if it is not.

You can also use the YEAR function in conjunction with other date functions, such as the MONTH and DAY functions, to extract the month and day from a date. For example:

=MONTH(A1)&”/”&DAY(A1)&”/”&YEAR(A1)

This formula would extract the month, day, and year from the date in cell A1 and combine them into a new date in the format “mm/dd/yyyy”.