刚接触,望大佬协助!!!
在这写公式。
DATEINMONTH(DATEDELTA(today(),-day(today())),1) 上月初
DATEDELTA(today(),-day(today())) 上月末
控件值 写公式
DATEINMONTH(MONTHDELTA(TODAY(),-1),-1)
DATEINMONTH(MONTHDELTA(TODAY(),-1),1)
DATEDELTA(DATEINMONTH(today(),1),1)
DATEDELTA(DATEINMONTH(today(),1),-1)