EXcel根据入职时间得出1年以下多少人一年以上多少人答:假设入职时间在C列 1、1年以下公式:=COUNTIF(C:C,">"&DATE(YEAR(TODAY()),MONTH(TODAY())-12,DAY(TODAY()))2、1年以上,并2年以下公式:=COUNTIFS(C:C,"<="&DATE(YEAR(TODAY()),MONTH(TODAY())-12,DAY(TODAY())),C:C,">"&DATE(YEAR(TODAY()),MONTH(TODAY())-24,DAY(TODA...