怎么公式结果不一样

m678

怎么公式结果不一样

解决
我求A2
=IF(MONTH(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"))>=9,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),TODAY(),"Y")-1,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),TODAY(),"Y"))

=IF(MONTH(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"))>=9,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),DATE(2023,8,31),"Y")-1,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),DATE(2023,8,31),"Y"))

精简后
=DATEDIF(TEXT(A2,"0000-00"),TODAY(),"Y")-(RIGHT(A2,2)*1>=9)

=DATEDIF(TEXT(A2,"0000-00"),DATE(2023,8,31),"Y")-(RIGHT(A2,2)*1>=9)


=DATEDIF(TEXT(A2,"#-00"),DATE(2023,8,31),"Y")-(MONTH(TEXT(A2,"#-00"))>=9)


谢谢

m678

好多公式 都是一知半解 偶尔套用下 ，不知所以然

袁勇

=IF(MONTH(C2)>=9,DATEDIF(C2,TODAY(),"Y")-1,DATEDIF(C2,TODAY(),"Y"))

m678

袁勇 发表于 2023-6-6 16:48
=IF(MONTH(C2)>=9,DATEDIF(C2,TODAY(),"Y")-1,DATEDIF(C2,TODAY(),"Y"))

谢谢
如果不用TODAY；若用具体年份  2023 也要是9月 学龄周岁
用2023-8-31和2023-9-1，哪种更合适

m678

m678 发表于 2023-6-6 16:55
谢谢
如果不用TODAY；若用具体年份  2023 也要是9月 学龄周岁
用2023-8-31和2023-9-1，哪种更合适

刚刚试用8-31和你的结果一样；
谢谢

m678

m678 发表于 2023-6-6 17:13
刚刚试用8-31和你的结果一样；
谢谢

我求A2
=IF(MONTH(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"))>=9,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),TODAY(),"Y")-1,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),TODAY(),"Y"))

=IF(MONTH(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"))>=9,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),DATE(2023,8,31),"Y")-1,DATEDIF(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"),DATE(2023,8,31),"Y"))

这样套用后可再精简吗

袁勇

m678 发表于 2023-6-6 17:17
我求A2
=IF(MONTH(TEXT(DATE(LEFT(A2,4),RIGHT(A2,2),1),"yyyy-m"))>=9,DATEDIF(TEXT(DATE(LEFT(A2,4),R ...

=DATEDIF(TEXT(A2,"0000-00"),TODAY(),"Y")-(RIGHT(A2,2)*1>=9)

=DATEDIF(TEXT(A2,"0000-00"),DATE(2023,8,31),"Y")-(RIGHT(A2,2)*1>=9)

yfan17

1. =DATEDIF(TEXT(A2,"#-00"),DATE(2023,8,31),"Y")-(MONTH(TEXT(A2,"#-00"))>=9)

复制代码