![](https://ask-fd.zol-img.com.cn/g7/M00/08/04/ChMkLGU_R6GINCxDAAC3BVzXa88AAWfbgFmPewAALcd281.jpg)
![](https://ask-fd.zol-img.com.cn/g7/M00/08/04/ChMkK2U_R6GILM41AAC8bfYb5-IAAWfbgFpqI0AALyF184.jpg)
日期 函数 说明
2017/4/1 2017/1/1 只需改动绿色单元格
2017/4/2 =A2+1 把B列的函数,编辑到A列里面
2017/4/3 =A3+1
2017/4/4 =A4+1
2017/4/5 =A5+1
2017/4/6 =A6+1
2017/4/7 =A7+1
2017/4/8 =A8+1
2017/4/9 =A9+1
2017/4/10 =A10+1
2017/4/11 =A11+1
2017/4/12 =A12+1
2017/4/13 =A13+1
2017/4/14 =A14+1
2017/4/15 =A15+1
2017/4/16 =A16+1
2017/4/17 =A17+1
2017/4/18 =A18+1
2017/4/19 =A19+1
2017/4/20 =A20+1
2017/4/21 =A21+1
2017/4/22 =A22+1
2017/4/23 =A23+1
2017/4/24 =A24+1
2017/4/25 =A25+1
2017/4/26 =A26+1
2017/4/27 =A27+1
2017/4/28 =IF(TEXT(A28+1,"mm")<>TEXT(A27,"mm"),"",A28+1)
2017/4/29 =IF(TEXT(A29+1,"mm")<>TEXT(A28,"mm"),"",A29+1)
2017/4/30 =IFERROR(IF(TEXT(A30+1,"mm")<>TEXT(A29,"mm"),"",A30+1),"")
=IFERROR(IF(TEXT(A31+1,"mm")<>TEXT(A30,"mm"),"",A31+1),"")