如果日期在A列的A2-A9,B列为季节,在B2中输入:
=IF(AND(3<=MONTH(A2),MONTH(A2)<=5),"春",IF(AND(6<=MONTH(A2),MONTH(A2)<=8),"夏",IF(AND(9<=MONTH(A2),MONTH(A2)<=11),"秋","冬")))
然后将公式填充至B9.
结果为:
1963-4-4 春
1973-6-9 夏
1947-12-1 冬
1944-3-10 春
1976-8-4 夏
1971-3-14 春
1947-6-30 夏
1943-9-30 秋