YEAR Function

The Excel YEAR function returns the year component of a date as a 4-digit number. You can use the YEAR function to extract a year number from a date into a cell or to extract and feed a year value into another formula, like the DATE function.

April 14, 2025 · 1 min · 48 words · Johnathan Carter

Note:dates are serial numbersin Excel, and begin on January 1, 1900.

Dates before 1900 are not supported.

To display date values in a human-readable date format, apply thenumber formatof your choice.

Excel formula: Zodiac sign lookup

you could use the DAY function to extract a day number from a date into a cell.

Excel formula: Get percent of year complete

Excel formula: Year is a leap year

Excel formula: Get year from date

Excel formula: Data validation date in specific year

Excel formula: Data validation allow weekday only

Excel formula: Convert date to Julian format

Excel formula: Get nth day of year

Excel formula: Sequence of years

Excel formula: Get fiscal year from date

Excel formula: Sum by year

Excel formula: Get months between dates

Excel formula: Count birthdays by year

Excel formula: Add years to date

Excel formula: Date is same month and year

Excel YEAR function

Excel MONTH function

Excel DAY function

Excel DATE function