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

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