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
+ Link
+ Link
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.