Excel最强玩法！用Excel做“动态日历表”，让你的好记性更牢固！

在B5单元格中输入公式：=IF(WEEKDAY(DATE($F 2 , 2, 2,G 2 , 1 ) ) = B 4 , D A T E ( 2,1))=B4,DATE( 2,1))=B4,DATE(F 2 , 2, 2,G 2 , 1 ) , I F ( W E E K D A Y ( D A T E ( 2,1),IF(WEEKDAY(DATE( 2,1),IF(WEEKDAY(DATE(F 2 , 2, 2,G$2,1))>B4,"",A6+1))，向右填充到H5单元格；