作者:乔山办公网日期:
返回目录:excel表格制作
=DATEDIF(G15,"2012/8/31","Y")&"岁百"&DATEDIF(G15,"2012/8/31","YM")&"月"&DATEDIF(G15,"2012/8/31","MD")
或
=TEXT(DATEDIF(G15,"2012/8/31","D"),"YY岁M月D日")
公式中度的"2012/8/31"换成该专日期所在单元格属
如果来20080121有A1,20150831在B1,那么输入以下公自式
=DATEDIF(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)),DATE(LEFT(B1,4),MID(B1,5,2),RIGHT(B1,2)),"y")
详见附图zd