Thread: Converting month name to number
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
  
Posts: 2,202
Default Converting month name to number
A1: (a month name....eg March)

Try this
=MONTH("01-"&A1)

In my example the formula returns: 3

Looks like you can shorten your formula a tad more; this seems to work...

=MONTH("1"&A4)

Rick
Reply With QuoteReply With Quote