my days in the Air Force...

Me too!

SAC - Kincheloe MI, Castle CA

--
Biff
Microsoft Excel MVP


"Rick Rothstein (MVP - VB)" wrote in
message ...
=--(A2&" "&A1&" "&A3)

or

=--(A1&" "&A2&", "&A3)

will return an Excel date. Just format the result as a date.

Interesting... you can shorten that to this...

=--(A2&A1&A3)

provided A1 contains the month name.

Rick

That is interesting. I never realized that NO separators could be used,

I'm not sure why, but when I saw Dave's DATEVALUE formula, it reminded me
of the date format that was used on my orders from my days in the Air
Force... I always thought 15Jan08 was a nice format for some reason
(although it "looked" better when the year wasn't decipherable as a day
value; e.g., 15Jan67), so it occurred to me to try it in the DATEVALUE
function... and it worked. Then I saw your --(<datestring) format and
figured I would try it there too... and, again, it worked.

Rick