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.
- How to convert a sequence of numbers into dates in Excel
- How to calculate the number of days in Excel
- 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.
- 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:
- Instructions on how to copy formulas in Excel
- Forgot password protected Excel file, what should you do?
- Instructions on how to translate languages on Excel spreadsheets
I wish you all success!
You should read it
- Basic Excel functions that anyone must know
- How to use Hlookup function on Excel
- How to use the SUM function to calculate totals in Excel
- How to use the LEN function in Excel
- How to use Excel's VALUE function
- How to use the MOD function and QUOTIENT function in Excel
- How to use COUNTIF function on Excel
- How to use MID functions to get strings in Excel
- How to fix the SUM function doesn't add up in Excel
- How to use the SUMIF function in Excel
- How to use the WRAPROWS function in Excel
- How to use the NPER function in Excel to plan loans and savings
May be interested
How to fix the date #VALUE error in Excel
How to fix Excel error 'The formula you typed contains an error'
How to automatically forward emails in Outlook
Instructions for setting the default font in Microsoft Word
How to change the default font on Google Docs
12 great free Keynote templates for your presentation