Extract the Year from a Date

Automate Excel

Extract the Year from a Date

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

Posted in Formulas |

One Response

  1. fmanheim Says:
    August 27th, 2008 at 8:27 pm

    Did not work. I got #Value as results

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.