在A1格中给定一个日期,在B1格中设定下列公式可求出给定日期所在月份的天数:
=IF(MONTH(A1)=12,DATEVALUE(CONCATENATE(YEAR(A1)+1,"/",1,"/",1)),DATEVALUE(CONCATENATE(YEAR(A1),"/",MONTH(A1)+1,"/",1)))-DATEVALUE(CONCATENATE(YEAR(A1),"/",MONTH(A1),"/",1))
然后在C1设定下列公式可以求出给定日期所在月份的星期天的个数:
=TRUNC((B1-1+WEEKDAY(DATEVALUE(CONCATENATE(YEAR(A1),"/",MONTH(A1),"/",1)),2))/7)