有其他方法吗,如果这样写,还要加一个IF判断12月
DATEINMONTH(MONTHDELTA(TODAY(),1),1)
DATEINMONTH(MONTHDELTA(TODAY(),1),-1)
DATEINMONTH(MONTHDELTA(today(),1),1)
DATEINMONTH(MONTHDELTA(today(),1),-1)
CONCATENATE(FORMAT(TODAY(),"yyyy-MM-01"),"~",FORMAT(DATEINMONTH(MONTHDELTA(today(),1),-1),"yyyy-MM-dd"))