因为要求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 ...