Date Math

[garygersh2]

I'm trying to create a formula that will calculate the differnce between any two dates in years, months and days. Is there an easy way to do this?

 

[Aladin Akyurek]

On 2002-08-27 10:22, garygersh2 wrote:
I'm trying to create a formula that will calculate the differnce between any two dates in years, months and days. Is there an easy way to do this?

[1]

=DATEDIF(A1,B1,"y")

where A1 < B1, gives the difference in years.

[2]

=DATEDIF(A1,B1,"m") the difference in months.

[3]

=DATEDIF(A1,B1,"d") the difference in days.

=YEARFRAC(A1,B1) is "similar" to [1].

=B1-A1 is similar to [3].

 

[Mark W.]

=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months "&DATEDIF(A1,A2,"md")&"days"