Often you may want to split a date into day, month and year in Excel:
Fortunately this is easy to do using the DAY, MONTH and YEAR functions in Excel and the following example shows how to do so.
Example: Separate Date into Day, Month and Year in Excel
Suppose we have the following column of dates in Excel:
Suppose we would like to split each date into separate columns that show the day, month and year.
We can type the following formulas into the following cells to do so:
- B2: =DAY(A2)
- C2: =MONTH(A2)
- D2: =YEAR(A2)
We can then click and drag each of these formulas down to the remaining cells in each column:
Each of the dates in column A have been split into three separate columns that show the day, month and year.
Note: The dates that we used were in a mm/dd/yyyy format, but the DAY, MONTH and YEAR functions in Excel are capable of extracting the day, month and year from other date formats as well.
The following tutorials explain how to perform other common operations in Excel: