What I found interesting was that you didn't have to use a space to separate
the month name from the day number; and in doing a quick experiment, Excel
doesn't even care about the order of those two elements either. As I said,
Excel is so flexible in how it interprets dates.

Rick


"Ron Rosenfeld" wrote in message
...
On Sat, 10 May 2008 10:55:34 -0400, "Rick Rothstein \(MVP - VB\)"
wrote:

Now **that** is an interesting shortcut. Excel sure can be surprising
sometimes. By the way, should you be wondering<g, now that I look at what
I
posted again, the PROPER function call was left over from a slightly
different direction I thought I was going to need to take (I simply forgot
to remove it). Still, I would have not come up with the shortcut you
posted
(Excel is so flexible in how it interprets dates).

Rick

It has to do with inputting an unambiguous month and date. In that case,
Excel will default to "this" year -- which is what you were doing with
your
formula.
--ron