Question

Excel的到期日怎么算

在excel中知道银行的“存入日”，知道“期限”，怎么用公式求出到期日来`？哪位大哥知道，说下啊``
那是期限是年`还必须得用公式写出来``

Answer 1

=DATE(YEAR(A1)+B1,MONTH(A1),DAY(A1))
A1是存入日，B1匙期限年

Answer 2

直接相加就行了
注：期限是天数

Answer 3

=IF(DATE(YEAR(A2)+INT((YEAR(TODAY())-YEAR(A2))/B2)*B2,MONTH(A2),DAY(A2)-1)>TODAY(),DATE(YEAR(A2)+INT((YEAR(TODAY())-YEAR(A2))/B2)*B2,MONTH(A2),DAY(A2)-1),DATE(YEAR(A2)+(INT((YEAR(TODAY())-YEAR(A2))/B2)+1)*A2,MONTH(A2),DAY(A2)-1))

Answer 4

自己查日历也知道