假设需判断的日期在A列(日期格式),则在B列输入:
=IF(VALUE(TEXT(A1,"m"))<4,"一",IF(VALUE(TEXT(A1,"m"))<7,"二",IF(VALUE(TEXT(A1,"m"))<10,"三","四")))&"季度"
下拉填充公式
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/0ff41bd5ad6eddc45f2e3b9236dbb6fd53663389?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追问不是这样的算法,我们老师让用if函数还有month月份来判断,把一二三月设为一季度,四五六月设为二季度,以此类推,七八九月为三季度,十十一十二月为四季度。
这个怎么做啊?
追答=IF(month(A1)<4,"一",IF(month(A1)<7,"二",IF(month(A1)<10,"三","四")))&"季度"
本回答被提问者采纳