Convert Date to String/Text

Hello,

Having terrible time trying to extract the month from a date, say, 21Sep17. Can't locate the right worksheet or VBA function to do this.
They all seem to want to go the other way - i.e. text to date. Anybody know an easy way to do this?

Edited Remark: Sorry, forgot to mention - I can use the Custom Format dialogue box in Excel and choose "mmm" for the format,
but the results are still a date with only the month showing in the cell. When I try to get that month into a text variable, I still end
up with a date, not a text string.

Thanks,

newbieobjectcoder

Hi @newbieobjectcoder, try this (with a date in A2):

Please Login or Register  to view this content.

...and if you want the 3-letter abbreviation:

Please Login or Register  to view this content.

Happy to help! If complete, please mark your thread as SOLVED (Thread Tools up top). Thanks -Lee