Keys to the Problem Calculate The Difference Between Two Dates

KAO wrote:I am trying to Calculate the Difference Between Two Dates so the result would be as it showen in the example below.A1 = 12/31/2008B1 = 07/31/2010C1 = Year.Month (For Example 1.7)Ostensibly:=DATEDIF(A1,B1,"y") & "." & DATEDIF(A1,B1,"ym")For more information about DATEDIF, see http://www.cpearson.com/excel/datedif.aspx.However, what answer do you want when A1 is 2/29/1980 and B1 is 2/28/2010?Typically, we want 30.0. Note that EDATE(A1,30*12) is 2/28/2010.