发布网友 发布时间:2022-05-14 03:28
我来回答
共1个回答
热心网友 时间:2024-02-23 08:24
如图
D2==DATEDIF(C2,TODAY(),"M")
下拉公式
A8=COUNTIF($D$2:$D$5,"<=6")
B9=SUMPRODUCT(($D$2:$D$5>=6)*($D$2:$D$5<=12))
C9=SUMPRODUCT(($D$2:$D$5>=12)*($D$2:$D$5<=36))