闰年的判断,就看能否被4整除是错的,应该: mod(year,4) =0 and mod(year,100)<>0 or mod(year,400)=0公式也不用那么复杂,29,30,31三天的单元格中,公式换成以下三行即可:
=IF(DAY(DATE(Q2,S2,29))<4,"",29) =IF(DAY(DATE(Q2,S2,30))<4,"",30) =IF(DAY(DATE(Q2,S2,31))<4,"",31)