How to separate the date, month, and year columns into 3 different columns in Excel

When processing date data in Excel, you will often need to make a request to separate the date, month, year into three different columns, or move the date, month, year of birth from number to letter . To make love This bridge is very simple, we will use basic Excel functions such as YEAR function, DAY function and combining time functions to convert time into text. The following article will show you how to separate the day, month and year into 3 separate columns and turn the time into letters.

1. How to convert a sequence of numbers into dates in Excel
2. How to calculate the number of days in Excel
3. How to separate thousands by commas in Excel

1. Separate Excel's day, month, and year into 3 separate columns

Step 1:

We enter dates into the Excel table. To separate the date into a separate column in the Date column, in cell C2, enter the formula = DAY (B2) and then press Enter.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 1

Then we will get the result as separate date. Drag the results of the first cell to the remaining cells in the Date column to show the results.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 2

Step 2:

In the Month column, enter the formula = MONTH (B2) and also press Enter to execute the formula.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 3

The result in the first cell also pulls down the remaining cells to show the full Month column.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 4

Step 3:

Next in the first cell of the column Enter the formula = YEAR (B2) and press Enter to proceed.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 5

And the results will also be separated in the Year column as shown.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 6

Note to the reader , in case you make the DAY function that says the #VALUE error is due to the date format on the computer being deviated from the date in Excel. Read the following article to fix errors.

1. How to fix the date #VALUE error in Excel

How to separate the date, month, and year columns into 3 different columns in Excel Picture 7

2. Convert date, month, and year from number to Excel

Step 1:

In the box you want to change the date, month, year from the number to the letter you enter the formula = 'date' & DAY (B2) & 'month' & MONTH (B2) & 'year' & YEAR (B2) as shown below, then press Enter.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 8

Step 2:

As a result, we will get the number of days in words as shown below.

How to separate the date, month, and year columns into 3 different columns in Excel Picture 9

The operation of separating time on Excel into separate columns is not difficult for users. You just need to enter the formula DAY, MONTH and YEAR for each column of time separately.

See more:

1. Instructions on how to copy formulas in Excel
2. Forgot password protected Excel file, what should you do?
3. Instructions on how to translate languages ​​on Excel spreadsheets

I wish you all success!