>
DATEDIF(G15,/8/31","Y")&"岁"&DATEDIF(G15,/8/31","YM")&"月"&DATEDIF(G15,/8/31","MD")
或
=TEXT(DATEDIF(G15,/8/31","D"),"YY岁M月D日")
公式中的/8/31"换成该日期所在单元格。
图文推荐