Question

excel已知生产日期和有效期怎么自动算出有效期的1/4到那天

如图，已知A产品的生产日期为20171129，保质期为5年，怎么自动算出保质期的1/4（也就是15个月）是到那天yyyy.mm.dd

Answer 1

=TEXT(TEXT(B2,"0000-00-00")+INT(SUBSTITUTE(C2,"年","")/4*365),"yyyy/mm/dd")

图片和公式已经更新。这次对了。

Answer 2

=TEXT(TEXT(TEXT(B2,"0000-00-00"),"yyyy/m/d")+SUBSTITUTE(C2,"年","")/4*365,"yyyy/m/d")