>... as generally all the dates in one sheet are of the same type (i.e. american, british, german etc), although I've seen exceptions to this :facepalm:.

Yep, I've seen that on a few occasions.