在excel表中怎么能显示保质期剩余的年数月数及天数答:公式很长的 =DATEDIF(TODAY(),DATE(YEAR(A1)+LEFT(B1,FIND("年",B1)-1),MONTH(A1)+MID(B1,FIND("年",B1)+1,FIND("个",B1)-FIND("年",B1)-1),DAY(A1)),"y")&"年"&DATEDIF(TODAY(),DATE(YEAR(A1)+LEFT(B1,FIND("年",B1)-1),MONTH(A1)+MID(B1,FIND("年",B1)+1,...