Excel: Split Date into Day, Month and Year

By /

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:

Excel split date into day, month and year

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.

x

Related terms:

  1. How to convert date to month and year format in Google Sheets?
  2. How do you calculate Year Over Year Growth in Excel
  3. How to Check if Month and Year Match Between Dates in Excel
  4. How do I sum values in Excel by month and year?
  5. How to Use split() Function in R to Split Data?
  6. How to Resample Time Series with groupby() in Pandas?
  7. How to Group by Month and Year in Pivot Table
  8. How to use DAY, MONTH, and YEAR Functions in SAS?
  9. How to Get Fiscal Year from a Date in Excel?
  10. How do I Convert Date to Quarter and Year in Excel?