# Microsoft Excel Tips - Function extract the year number from a date

**URL:** <https://forumautomation.com/t/microsoft-excel-tips-function-extract-the-year-number-from-a-date/357>\
**Category:** Microsoft Excel Tips\
**Created:** [March 25, 2015, 4:33am UTC](https://forumautomation.com/t/microsoft-excel-tips-function-extract-the-year-number-from-a-date/357 "2015-03-25T04:33:54Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![denizen](https://forumautomation.com/letter_avatar_proxy/v4/letter/d/848f3c/32.png) [@denizen](https://forumautomation.com/u/denizen)\
**Post date:** [March 25, 2015, 4:33am UTC](https://forumautomation.com/t/microsoft-excel-tips-function-extract-the-year-number-from-a-date/357/1 "2015-03-25T04:33:55Z")

</div>

Date Year 25-Dec-98 1998 =YEAR(C4)

What Does It Do? This function extracts the year number from a date.

Syntax =YEAR(Date)

Formatting The result is shown as a number.
