怎么用excel将一下区域区分为3天以下 3-30天 1-3个月 3-6个月 6-12...答:=IF(A2="","",LOOKUP(VLOOKUP(B2,{"年",360;"月",30;"日",1},2,0)*A2,{0,3,30,90,180,360,720,1080},{"3天以下","3-30天","1-3个月","3-6个月","6-12个月","1-2年","2-3年","3年以上"}))效果如图:请注意着色部分的测试数据,也就是以年/月计但是不满1年...
Excel if函数判断某个日期是否在某个区间内?答:=IF(DATEDIF(A2,B2,"m")<6,"6个月之内",IF(DATEDIF(A2,B2,"m")<12,"6-12个月内","12个月之上"))如果A列的日期有可能晚于B列的日期,那么在日期计算那里在套上一个IFERROR函数来调换一下起止日期就好了,=IF(IFERROR(DATEDIF(A2,B2,"m"),DATEDIF(B2,A2,"m"))<6,"6个月之内"...