Hey guys

How can I take "October" and convert it to the corresponding month number 10?

I thought Format() would be the way to go, but I'm having no luck...

I'm not looking for a Select Case statement (or big nested IF), but a VBA (or worksheetfunction) native way.

This seems easy, but I can't figure it out...

TIA