How to separate date from Microsoft excel?

Asked By 10 points N/A Posted on -

I have a Microsoft excel sheet including some dates. I just want to separate year, month and day to three separate columns. There are more than 300 days. Can someone tell me an easy way to do this?

Answered By 0 points N/A #155272

How to separate date from Microsoft excel?


In Microsoft excel it is easily can be separated year, month & day easily.

In order to do that all the dates should be in the correct date format. Assuming that you have the correct date format I will explain you how separate date using an example.

Please see the below picture.

Enetr Day date in Excel

According to that date schedule I will show you how to take year, month, date to each column.

First type the following formula in cell B3.


Year in different column

Then type this formula in cell C3.


Monther in other column

Now type this formula in cell D3.


Day in different column

Now copy all formulas to below the cells. Then you will be able to get the answer you want to get.

Formula use in excel to spilt data

Login/Register to Answer

Related Questions