Excel is a spreadsheet program that is used by many people, especially for office workers, accountants. When processing date data on worksheet, users need to separate date and year in Excel into different columns to compare the data. Readers can use the b

Excel is a spreadsheet processing program in the Microsoft Office toolkit that helps users enter data and calculate quickly and accurately. When using Excel to process data related to dates, users often have to separate dates and years into different columns to facilitate data entry and compare results. If you do not know how to split the date in Excel , readers can refer to the instructions in the article below and follow the steps.

How to split May day in Excel

Instructions for splitting May date in Excel into columns

Link to download Excel versions:
+ Link Download Excel 2021
+ Link Download Excel 2019
+ Link Download Excel 2016

Step 1: Open Excel =>Open a data table with date or create 1 data table containing date year.
Step 2: To split the date into a separate column in the date column E6 , use the formula =DAY(D6)

Then drag the result in the first cell down to the remaining cells so that the formula is applied.

Step 3: Split month into a separate column, you enter the formula =MONTH(D6) and column F6.

Then apply the formula to the next lines by dragging down the remaining cells.

Step 4: Split the year into a separate column, you use the formula =YEAR(D6) into column G6.

Then drag and mouse so that the formula applies to the next lines

When using the function in Excel encounters #VALUE error but do not know how to handle it, readers can refer to the instructions in the article below and follow the steps to fix the error.

https://thuthuat.taimienphi.vn/cach-tach-ngay-thang-nam-trong-excel-69483n.aspx
Above is a tutorial on how to split dates in Excel to help readers split data and can get any day or month or year in the data table.