By the way, the 23rd day of September, 2006 is a Saturday.
Looks like you have Text in A1, that will happen when you put the text in front of the date in the same cell.
If you only have the true date in A1, formated as you listed, then VoG II's formula will work.