Thanks RD,
I am only selecting cell A1. I am seeing a problem with the workbook
i'm working with. I tried your formula on another system running the
same version of excel. When I entered the CF, the cell didn't turn
green prior to me entering a date. But it didn't turn green after I
entered a date either.

So I deleted my workbook and started brand new. I can now replicate
the behavior I just wrote about.

I wanted to ask you what Number format are you using? Maybe I'm using
the wrong format, if that makes a difference...

Russ