Date standard format:
The standard format of Gregorian calendar date is; 201February 6, 7; Or: 20 17-02-06.
The standard format of lunar calendar date is: the 19th day of the twelfth lunar month in Dinghai year.
The standard format of the official calendar date is: Ding Hai Year, Ren Yin Year and Wei Xin Month.
The date shall not be written with decimal point or pause instead of year, month and day, such as February 6, 2007; 2007、2、6。
The year number of the year, month and day must be written completely and cannot be abbreviated as: February 6, 2007; Or: 07-02-06.
For example, it is also 1987 June 1, and Americans are used to writing 6.1.1987; Europeans are used to writing1.6.1987; Asians are used to writing 1987.6. 1.
1987, the international organization for standardization announced the latest date writing method to formulate a unified specification, that is, it is written in the order of year, month and day, but 1 digit should be preceded by "0", for example, 1987.06.06438+0.
Dates in the extended data Excel can participate in calculation and can only be written in the standard format of Gregorian calendar dates.
Namely; February 6, 2007; Or: February 6, 2007.
To use the real-time walking date, you can enter the date function: "=TODAY ()". Date function can participate in calculation.
If you right-click/set cell format/date/select a format with weeks, this date-only format will be automatically converted to "Tuesday, February 6, 2007" format with weeks.
This is also a simple way to query the day of the week with Excel. Modifying the date in the cell with the format of year, month, day and week will automatically display the day of the week. If the date in the cell "Tuesday, February 6th, 2007" is changed to "20 12-9", "Thursday, 2012" will be automatically displayed.
Baidu Encyclopedia-Date (Chinese Vocabulary)