Changing Dates into a Month on VBA

sjpm84 - Aug 31, 2010 at 08:04 AM
 Trowa - Aug 31, 2010 at 09:28 AM

I have a column which lists the dates of certain activities in dd/mm/yy format. In the next column I would like the macro code in vba to recognise the date and simply tell me the month in the second column. I don't want a standard excel forumla and fill it down...surely there is a way?!

1 response

Hi sjpm84,

Why do you want to use a macro?

You don't even need a function to get this done.

Simply copy the entire column or range that has the dates and paste it in the column next to it. Then goto cell properties (Ctrl+1 or right click and then bottom option) for the entire column or range, goto number tab and enter a manual format as "mmmm".

Best regards,