假设在A列得到结果，从A1开始，以今天日期为起点，那么A1中输入
=TEXT(TODAY()+INT((ROW()-1)/3),"e-mm-dd")&TEXT(MOD(ROW(),3),"[=2]中午;[=1]上午;下午")
向下复制公式即可
=TEXT(DATE(2018,8,10)+INT(ROW(A3)/3),"m月d日")&CHOOSE(MOD(ROW(A3),3)+1,"上午","中午","下午")下拉
