Four respected Excel gurus (Norm Harker, Bob Phillips, Frank Kabel, and Ron de Bruin) have created an add-in to ease date entry in Excel. From Ron’s site:
QDE is a fully-functional Excel Add-in that provides quick input of dates, in all international formats. It handles quick data entry interpretation and reflects the three interacting issues of Date System, Day, Month Year ordering, and number of digits used in the quick date entry. In most … Operating System settings. With QDE you enter just as many digits as needed to clearly identify the date, QDE will do the rest.
You can download it here: www.rondebruin.nl/qde.htm
An add-in like this has been a long time coming, and with these four guys as the authors, you can be sure it’s top quality.