这个阶段 是怎么说的? 每10天为 一个阶段???
if(DAY(TODAY())<=10,DATEINMONTH(TODAY(),1),if(10<DAY(TODAY())&&DAY(TODAY())<=20,DATEDELTA(DATEINMONTH(TODAY(),1),10),if(20<DAY(TODAY())&&DAY(TODAY())<=31,DATEDELTA(DATEINMONTH(TODAY(),1),20),DATEDELTA(DATEINMONTH(TODAY(),1),20))))
这个是开始日期
if(DAY(TODAY())<=10,DATEDELTA(DATEINMONTH(TODAY(),1),9),if(10<DAY(TODAY())&&DAY(TODAY())<=20,DATEDELTA(DATEINMONTH(TODAY(),1),19),if(20<DAY(TODAY())&&DAY(TODAY())<=31,DATEINMONTH(TODATE(),-1),DATEINMONTH(TODATE(),-1))))
这个是结束日期