Extract the Year from a Date

January 30th, 2005 | Categories: Formulas | Tags:
-->

You can extract the year from a date in Excel by using the Year function.

Assuming a date in Cell A1, the following will display the Year:

=Year(A1)

extractyear

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. fmanheim
    August 27th, 2008 at 20:27
    Reply | Quote | #1

    Did not work. I got #Value as results

  2. Jenel
    June 30th, 2009 at 20:27
    Reply | Quote | #2

    Didn’t work for me either. My date started as 3/26/1990 but came out as 6/12/1905. WTF?

  3. Jazzer
    July 2nd, 2009 at 05:51
    Reply | Quote | #3

    fmanheim: You are probably using different date system than in the example. Try using the format as selected in your computers regional settings. Like here in Finland 30.12.1971

    Jenet: Your target cell is formatted as date. Select the cell and from the cells properties (ctrl+1), change the Number -> Category from Date to General

  4. czyla
    August 23rd, 2011 at 15:26
    Reply | Quote | #4

    You must format the target cell as a number then the formula works!