year on year tracking

[Tony Chapman]

many thanks to Luke for a quick and informative answer. It gives me the basis
of what i want. What i should have said is that the ages of the children need
to be in years and months (or simply months) so that a more exact measure can
be provided between age and assessed age. I could simply type in the months
as a figure after working it out separately but i have been trying the year
and month functions to do it for me and not quite getting it right. if i
could and then fit it into lukes solution i think i may have it. EG. Child
born on say 01/01/2000 takes a test on 03/03/2009 and gets an assessed
reading age of 8 years 2 months (actual age 9 years 3 months). Next test is
on 04/03/2010 and he/she gets 10 years 2 months assessed age ( actual age 10
years 3 months) so the child has improved and the measure of the improvement
is the change in the difference between actual and assessed year on year Can
you help further

 

[Jacob Skaria]

If you are looking at finding difference in months between 2 dates use
DATEDIF() function

with start date in A1 and end date in B1
=DATEDIF(A1,B1,"m")

OR
Put DOB in A1 and
In B1 enter the below formula
=IF(A1+0=0,"",DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&"
months " & DATEDIF(A1,B1,"md")&" days")


'Age upto today with DOB in A1
=IF(A1+0=0,"",DATEDIF(A1,TODAY(),"y")&" years "&DATEDIF(A1,TODAY(),"ym")&"
months " & DATEDIF(A1,TODAY(),"md")&" days")

 

[Eduardo]

Hi
Try
=DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months
"&DATEDIF(D5,E5,"md")&" days"

Change D and E to fit your needs

 

[Tony Chapman]

brilliant. thank you very much. calculations of ages are spot on - though i
didn't need the days bit.

 

[Tony Chapman]

many thanks it works out the ages brilliantly

Hi
Try
=DATEDIF(D5,E5,"y")&" years "&DATEDIF(D5,E5,"ym")&" months
"&DATEDIF(D5,E5,"md")&" days"

Change D and E to fit your needs