Extracting Dates

[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.

 

[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. 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)

 

[Jacob Skaria]

Hey !! Congrats on your Bronze level..

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!

 

[Ms-Exl-Learner]

Thank you sir!!!