Rename sheet from ddMMMyyyy (alphanumeric) to yyyymmdd (numeric only)

[Dr. Demento]

I've got a large number of worksheets that are named as ddMMMyyyy (ie, 02Jan2012) that I would like to name to a numeric only format (yyyymmdd: 20120102). Additionally, since some sheets are not named as a date, I would like to test them first (something akin to ISDATE) but I keep coming up short. Any ideas for a function??

Thanks y'all.

 

[Dr. Demento]

Wow, Rick! That's some excellent code/knowledge. Thank you for sharing!!