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)

--
Biff
Microsoft Excel MVP


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