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