Looks like you all resolved this on 'European' time.

Quote Originally Posted by JohnTopley View Post
Lesson here is obvious : NEVER use text for dates!
Could not agree more. Think we have all run into this problem early on in our Excel careers, and you finally just naturally avoid it.