Computers and commuters need the year first

USA convention m/d/y
UK convention d/m/y (very logical)
international good sense y/m/d

Excel can be configured to display date in cells as any one of the 3 above plus any logical text therefore, but why did Micro$oft insist on only accepting the US convention when it came to VBA? I have to contort my programs with all sorts of algorithms to find the most likely date I have been sent.

Stanron & DtG - take note - you are mostly correct, which in compuspeak means - I am afraid - wrong. And you won't know when wrong hits you! It is down to the programmer's intelligence, and I am one. (and have some - amount unspecified).