Recognised Formats

The list of recognised date formats will vary from system to system.
This list will also depend on the users settings.
When a date format is recognised, Excel functions will convert it to its serial number automatically.
This list of date formats that are accepted by functions is the same list as the date formats that are accepted in cells.

Default Formats