IF(DATEDIF(MONTHDELTA(FORMAT(TODAY(),"yyyy-MM") + "-01",1),TODAY(),"D")<=7, MONTHDELTA(FORMAT(TODAY(),"yyyy-MM") + "-01",1) -7 ,DATEDELTA(FORMAT(TODAY(),"yyyy-MM") + "-01",-7))
帆软 统计月
最新推荐文章于 2024-01-19 14:53:46 发布
IF(DATEDIF(MONTHDELTA(FORMAT(TODAY(),"yyyy-MM") + "-01",1),TODAY(),"D")<=7, MONTHDELTA(FORMAT(TODAY(),"yyyy-MM") + "-01",1) -7 ,DATEDELTA(FORMAT(TODAY(),"yyyy-MM") + "-01",-7))