Hi Nitya,

Am Thu, 28 May 2015 01:24:24 -0700 (PDT) schrieb Nitya Satheesh:

Thanks Howard! An issue I have is those dates from column c onwards are typed, so I'm not sure Excel recognizes them as dates. How can I solve this ?

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


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