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,...
EXCEL怎样通过日期区间自动填写另一个单元格的内容答:图2中,H3单元格的公式为:=IF(OR(D3="",D3<DATE(1994,7,30)),"",IF(D3<DATE(2000,7,30),"青年组",IF(D3<DATE(2003,7,30),"少年B组",IF(D3<DATE(2006,7,30),"少年A组",IF(D3<DATE(2008,7,30),"儿童C组",IF(D3<DATE(2010,7,30),"儿童B组",IF(D3<DATE(2012...