在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)),"ym")&"个月"&DATEDIF(TODAY(),DATE(YEAR(A1)+LEFT(B1,FIND("年",B1)-1),MONTH(A1)+MID(B1,FIND("年",B1)+1,FIND("个"...