Assistance with =DateDif function

[plannerg]

I am hoping someone can help me here, Im not sure if its an issue with 2012 being a leap year.

A1 cell contains a date of birth (eg 29/12/1983)
B1 cell contains the date 1/1/2012

I want to find the years and days between the two dates

=DATEDIF(A1,B1,"Y") gives me the correct answer of 28

however

=DATEDIF(A1,B1,"YD") gives me 116 when I would have thought it should be 2.

Am I on the wrong track here......is someone able to point me in the right direction?...............Thanks.

[Fotis1991]

Hi

Try this. A1=day of birth>A2=the date that you want(01/01/2012)

=DATEDIF(A1;A2;"y") & " Years " & DATEDIF(A1;A2;"ym") & " Months, " & DATEDIF(A1;A2;"md") & " Days"

Change the semi-colons to gomma, if you have to do.

Hope to helps you.

[plannerg]

Thanks but that returns: 21 Years 0 Months, 114 Days

I would have thought the difference is 21 Years 0 Months, 1 Day?

[Fotis1991]

??

Take a look to the example...