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.