yue = Cells(1, 1) '读取a1的月份
If yue = 2 Then '如果是2月
nian = Year(Now)
If nian Mod 400 = 0 Or nian Mod 4 = 0 Then '判断是否是闰月,闰月29天,其他则是28天
ri = 29
Else
ri = 28
End If
End If
If (yue = 1) Or (yue = 3) Or (yue = 5) Or (yue = 7) Or (yue = 8) Or (yue = 10) Or (yue = 12) Then '大月31天
ri = 31
End If
If (yue = 4) Or (yue = 6) Or (yue = 9) Or (yue = 11) Then '小月30天
ri = 30
End If
Range("a3:a33").ClearContents '清除之前的内容
For i = 1 To ri '循环写入日期
Cells(i + 2, 1) = yue & "月" & i & "日"
Next i