Thank you sir!!!

--------------------
(Ms-Exl-Learner)
--------------------


"Jacob Skaria" wrote:

Hey !! Congrats on your Bronze level..


"Ms-Exl-Learner" wrote:

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

"dwake" wrote in message
...
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.