excel表格统计使用年限

有如下表格

要求如下，不增加新的列，不先计算现在和生产日期的时间差，直接在下表中体现，能有做到，谢谢！

刚才忘记说了，这个计算要是动态的，也就是说我2015年打开和2016年打开，里面的数据是会实时修正的，谢谢！

1年以下：
=SUMPRODUCT(N(DATEDIF($C$2:$C$15,TODAY(),"y")=0))
1-2年：
=SUMPRODUCT(N(DATEDIF($C$2:$C$15,TODAY(),"y")=1))
2-3年：
=SUMPRODUCT(N(DATEDIF($C$2:$C$15,TODAY(),"y")=2))
3-4年：
=SUMPRODUCT(N(DATEDIF($C$2:$C$15,TODAY(),"y")=3))
4-5年：
=SUMPRODUCT(N(DATEDIF($C$2:$C$15,TODAY(),"y")=4))
5年及以上：
=SUMPRODUCT(N(DATEDIF($C$2:$C$15,TODAY(),"y")>=5))
Datedif(开始日期,结束日期,"y")得到的结果是周年，对年对月对日，因此，结果为=1就是1周年以上不到2周年，其他同理。

看了你的求助，一是想不出好的方法。但你提示“急”，先介绍一个笨方法：

c4单元格公式:

=a4&if(a3=a4,"",a3)&if(a2=a4,"",if(a2=a3,"",a2))&if(a1=a4,"",if(a1=a3,"",if(a1=a2,"",a1)))

c5单元格公式:

=left(a5&if(a4=a5,"",a4)&if(a3=a5,"",if(a3=a4,"",a3))&if(a2=a5,"",if(a2=a4,"",if(a2=a3,"",a2)))&if(a1=a5,"",if(a1=a4,"",if(a1=a3,"",if(a1=a2,"",a1)))),4)

c6单元格公式:

=left(a6&if(a5=a6,"",a5)&if(a4=a6,"",if(a4=a5,"",a4))&if(a3=a6,"",if(a3=a5,"",if(a3=a4,"",a3)))&if(a2=a6,"",if(a2=a5,"",if(a2=a4,"",if(a2=a3,"",a2))))&if(a1=a6,"",if(a1=a5,"",if(a1=a4,"",if(a1=a3,"",if(a1=a1,"",a1))))),4)

将c6单元格公式拖下去，效果如图：