Extracting Dates

D

dwake

I have a column of random dates ranging from 1-1-2007 to 1-1-2017 in the
format of ddmmmyy. I am trying to create two more columns of data, one
containing the year, and one containing the month. Is it possible to use a
formula to extract these without having to sort individually and input
manually.
 
M

Ms-Exl-Learner

Assume that your Date is in A1 cell

Copy and paste the below formula in B1 cell for getting the Month.
=MONTH(A1)

Or

=TEXT(A1,"MMM")

Copy and paste the below formula in C1 cell for getting the Year.
=YEAR(A1)

Remember to Click Yes, if this post helps!
 
T

T. Valko

If they are true Excel dates try these.

For the month number: 1, 2, 3 ... 12

=MONTH(A1)

For the short month name: Jan, Feb, Mar ... Dec

=TEXT(A1,"mmm")

For the long month name: January, February, March ... December

=TEXT(A1,"mmmm")

For the year:

=YEAR(A1)
 
J

Jacob Skaria

Hey !! Congrats on your Bronze level..


Ms-Exl-Learner said:
Assume that your Date is in A1 cell

Copy and paste the below formula in B1 cell for getting the Month.
=MONTH(A1)

Or

=TEXT(A1,"MMM")

Copy and paste the below formula in C1 cell for getting the Year.
=YEAR(A1)

Remember to Click Yes, if this post helps!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top