Hi,

Am Thu, 28 May 2015 10:40:02 +0200 schrieb Claus Busch:

try in C TextToColumns. If the entry changes to real date copy it to the
right = Fill Month
Or write 01.05.2011 in C1 and format it MMM-YY and copa to the right

you can also change your text into a real date with following array
formula:
=DATE(2000+RIGHT(C1,2),MATCH(LEFT(C1,3),TEXT(ROW(1 :12)*28,"MMM"),0),1)
and insert the formula with CTRL+Shift+Enter


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional