Convert text to date

FWIW, another slightly shorter alternative for getting a month number from a mmm string is to use:

=MONTH(1&A1)

where A1 holds "Jan" etc...