Hi

Copy the data from each column to a new Sheet, pasting each block below the
first one in column A
Select column ADataText to columnsFixed WidthNextNextDateM/d/yFinish

You will now have valid dates in column A and alongside in column B, your
data for that day.
If you did want the Month, then insert a column at B and in B2
=TEXT(A2,"mmm")
Copy down

--
Regards
Roger Govier

"PointerMan" wrote in message
...
I have about 30 columns of data that start with a date in each of them. I
want to pull all of the January (February, etc) dates from each of the
columns into one column in another worksheet. My second column will have
titles January, February, March, etc and will be filled with the
appropriate
data from the first sheet.