Separating month from a date series in a column

[ajang]

Hi,

I have a date column in my excel spreadsheet (file attached). I want to separate month out of it and get it in a separate column. I do it using “text to column” tool. However, it will be great if I can do it in Macro because I do it for many sheets in a day.

Thank you in advance,
Ajang

[xladept]

Hi ajang,

Try this:

Please Login or Register  to view this content.

[ajang]

It works perfectly...Thank you so much Xladept

[xladept]

You're welcome!