因为要求excel表中日期那列单元格能够接受得数据可以是年份 (yyyy)，也可以是年月 (yyyy/mm)，也可以是年月日 (yyyy/mm/dd)。excel本身提供的“设置单元格式”那里只能选择一种数据格式。 还请各位牛人指点一二！

The International Standardisation Organisation has set yyyy-mm-dd as the internationally accepted way to represent time and date. It moves from the biggest unit of time (years) to the smallest (days).

To get results after a given date, add “ after:YYYY-MM-DD ” at the end of your search. For example, searching “top 10 horror movies after:2018-12-31” will provide you with results that ...

Today is a very special occasion – the date is a palindrome, meaning it is the same when read forwards and backwards. It is February 2, 2020, or 02/02/2020, in both the MM/DD/YYYY format and the ...

Adding to the universal appeal and rarity of Sunday's date is its achieving the eight-digit palindrome pinnacle, working in the cross-cultural formats of MM-DD-YYYY and DD-MM-YYYY.