When you’re talking about formatting dates, you’ve got lớn lead with this xdcd comic:
Bạn đang xem: yyyy mm dd
Excel does crazy things with dates. It stores them internally as an integer, counting the days since 1900-01-01. Wait that’s only for Windows; on Macs, it counts the days since 1904-01-01.
So, be careful lớn kiểm tra that the dates haven’t been mangled when your data come out of Excel.
Excel also has a tendency lớn turn other things into dates:
Personally, I’d be inclined lớn use a plain text format for columns in an Excel worksheet that are going lớn contain dates, ví that it doesn’t bởi anything lớn them:
- Select the column
- In the thực đơn bar, select Format → Cells
- Choose “Text” on the left
Alternatively, you could create three separate columns with year, month, and day. Those will be ordinary integers, and so Excel won’t mess them up.
But really what I wanted lớn emphasize here: be consistent in the way
in which you write dates. And really, always use the
format, as in the xkcd comic, above (or
put the year, month, and day in separate columns, if you want).
I have an old Excel spreadsheet in front of mạ that looks a bit like this:
I don’t quite remember what those
e’s were for, but having
different date formats within a column can cause headaches later.
Xem thêm: công bội của cấp số nhân
Use care about dates, and be consistent.
Next up: Fill in all of the cells.
(Previous: Be consistent.)