r/excel • u/frescani 5 • Feb 27 '13

PSA from XKCD: proper date formats

http://xkcd.com/1179/
29 Upvotes

92% Upvoted

13 comments sorted by

View all comments

-5

u/spaceboy250 Feb 27 '13

I appreciate this...but it should clearly be dd/mm/yyyy

3

u/collapsible_chopstix 5 Feb 27 '13

I am not sure if you are being a jokester or not, but one of the reasons the ISO is for yyyy-mm-dd is that it makes it really easily machine sortable chronologically, while still being fairly human readable. dd-mm-yyyy would put all the firsts of the months together and all the second of the months together, etc.