YEAR function in Excel
YEAR returns the year of a date.
Syntax
=YEAR(serial_number)
| Argument | Required? | What it is |
|---|---|---|
| serial_number | Required | The date to take the part from. |
Practise YEAR in a live spreadsheet
There is no dedicated lesson yet. Browse all lessons.
Related date functions
- DATEBuilds a date from year, month and day.
- TODAYReturns today's date.
- DATEDIFDifference between two dates in "Y", "M" or "D".
- DAYSNumber of days between two dates.
- EDATEDate a number of months before or after.
- EOMONTHLast day of the month, months away.
- WORKDAYDate a number of working days away.
- MONTHReturns the month of a date.