周岁计算问题

1、计算退休时间

B2=EDATE(A2,60*12)

2、整年计算

C2=DATEDIF(A2,TODAY(),"y")

3、整月计算

D2=DATEDIF(A2,TODAY(),"m")

4、整日计算

E2 =DATEDIF(A2,TODAY(),"d")

5、年月计算

F2 =DATEDIF(A2,TODAY(),"y")&"年零"&DATEDIF(A2,TODAY(),"ym")&"个月"

6、月天计算

G2=DATEDIF(A2,TODAY(),"m")&"个月零"&DATEDIF(A2,TODAY(),"md")&"天"

7、年天计算

H2=DATEDIF(A2,TODAY(),"y")&"年零"&DATEDIF(A2,TODAY(),"yd")&"天"