自己做了一次提示我输入的公式存在错误
公式为:
=DATEDIF(A1,TODAY(),"y")&"年"&DATEDIF(A1,TODAY(),"ym")&"月"&DATEDIF(A1,TODAY(),"md")&"天"
如图所示:
3. X月X天:
=DATEDIF(A1,TODAY(),"m")&"月"&DATEDIF(A1,TODAY(),"md")&"天"