In this video we discuss how to get, or extract the year from a given date in a cell in an excel workbook. We go through a detailed example step by step showing the process
Transcript/notes
Let’s say that you need to extract the year for a given date, such as in this example. To do this, left click on the answer cell, in this example cell D2, then type in a comma. Next, type in te, and a drop down box will appear. In the box, left double click on TEXT.
From here, we left click on the date, cell A2. Next, we type in a quotation marks and then type in 4 y’s for year. Then type in another quotation marks, followed by a parenthesis. Then hit the enter key and we have our answer of 2001.
And this will work for a variety of other types of date formats, as you see here.