Excel中根据日期函数怎么求期限？

假设日期分别在 A1(01-01-12 ),A2(1-01-13)公式1 =year(a2)-year(a1)或者=datedif(a1,a2,"y")