[SOLVED] RE: Function or formula to convert "text" month to number of month

Perfect! Thanks Kevin!
Steve

"Kevin Vaughn" wrote:

> With April in B18, this worked for me:
> =MONTH(DATEVALUE(B18 & " 1, 2006"))
> --
> Kevin Vaughn
>
>
> "Steve Vincent" wrote:
>
> > Is there a function to convert the text name of a month (e.g., "April") to
> > its corresponding number (e.g., "4")? If not, the only workaround I can
> > think of would be a long, nested IF function (e.g., =IF(A1="January",
> > "1",IF(A1="February", "2", . . . etc. . . ))))))))
> >
> > TIA for any help offered,
> > Steve

Also...

=MONTH(A1&"-0")

with

"Dec" or "december" etc. in A1