How to use Excel YEAR Function

    how to use excel year function

    Quick Intro

    Use Excel YEAR Function to get the year from a date. In simple words, it will return year value from a date. For example, from 12-Aug-2016 it will return 2016.



    serial_number A serial number which represents the date from which you want to get the year value.

    More Information on Excel YEAR Function

    • Excel store dates as serial numbers.
    • It will only return year number if reference date is valid.
    • You can only extract year number from a date which is after 01-01-1900.
    • It always returns year in four digits.


    In the below example, I have used year function to get year number from the dates. You can use this function where you have dates in your data & you only need year number.

    You can also use TEXT Function to get the year from a date.

    use excel year function with to get year number

    In the below example, I have used today function to get year number from the current date. It will always update the year whenever you recalculate your worksheet.

    use excel year function with today function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel YEAR Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.There is also you have

    There are also you have MONTH | DAY functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.