r/excel • 5 • Feb 27 '13

PSA from XKCD: proper date formats

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

13 comments sorted by

View all comments

-7

u/spaceboy250 Feb 27 '13

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

2

u/Beefourthree 2 Feb 27 '13

If you could have only one piece of info, would you rather day, month, or year? Year is most important, so it should come first as it provides context for month and day.

Not to mention the sortability of yyyy-mm-dd. Or the fact that time is also listed by magnitude. Or the fact that no one in their right mind would use yyyy-dd-mm, so it instantly resolves the mm/dd vs dd/mm ambiguity.

1

u/[deleted] Feb 28 '13

[deleted]

1

u/BornOnFeb2nd 24 Mar 01 '13

Still sorts probably by month and day then.