How to extract or get the year, month and day from date list in Excel?

For a date list, do you know how to extract or get the year, month and day number? See screenshot below. In this article, we will show you formulas of getting year, month and day number separately from a date list in Excel.

Extract/get the year, month and day from date list in Excel

Extract the year number
Extract the month number
Extract the day number

Extract/get the year, month and day from date list in Excel

Take below date list as an example, if you want to get the year, month and day numbers from this list, please do as follows step by step.

Extract the year number

1. Select a blank cell for locating the year number, such as cell B2.

2. Copy and paste formula =YEAR(A2) into the Formula Bar, then press Enter key. Drag the Fill Handle down to the range you need to get all year number from the list.

Extract the month number

This section shows you the formula of getting the month number from the list.

1. Select a blank cell, copy and paste formula =MONTH(A2) into the Formula Bar and press the Enter key.

2. Drag the Fill Handle down to the range you need.

Then you will get the month numbers of the date list.

Extract the day number

The getting day number formula is as simple as the formulas above. Please do as follows.

Copy and paste formula =DAY(A2) into a blank cell D2 and press Enter key. Then drag the Fill Handle down to the range to extract all day numbers from the referenced date list.

Now the year, month and day numbers are extracted from the date list as above screenshot shown.