How to separate date from Microsoft excel?

Asked By Floyed Brice 10 points N/A Posted on - 08/21/2012

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?

• Status: Open
• Question Views: 1311
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Geisha Nitta 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.

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(A3)

Then type this formula in cell C3.

=Month(A3)

Now type this formula in cell D3.

=DAY(A3)

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

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 08/21/2012
• Question Category: MS Excel