And using Ron's formula as a base, this can be shorted to...

=--(A2&A1&A3)

Rick


"Rick Rothstein (MVP - VB)" wrote in
message ...
The following will return the date where the month name is in A1, the day
of month is in B1, and the year is in C1.

=TEXT(DATEVALUE(A1&" "&B1&", "&C1),"mmm dd, yyyy")

The value in A1 can be either the 3-character month abbreviation (Jan,
Feb, etc) or the full month name (January, February, etc).

I just posted this (using different cell references) to Dave's posting....

=DATEVALUE(B1&A1&C1)

Rick