DAY(ROW()-1) 当前单元格(日期序列数)DAY(EOMONTH(TODAY(),0)) 转换后的本月最后一天的日期序列数DAY(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(ROW()-1))) 当月日期中日序列数与单元格A2为起始计数的"1号日,ROW()函数,A1就返回1,A2就返回2,第一行被表字段名占用,所以起始计数得-1"A1="日序"A2-A32=[" =IF(DAY(ROW()-1)<=DAY(EOMONTH(TODAY(),0)),DAY(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(ROW()-1))),"") "]
百度贴吧——全球领先的中文社区
来自：tieba.baidu.com/index.html?sharefrom=tieba