year on year tracking
 

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

year on year tracking
 

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")

--
If this post helps click Yes
---------------
Jacob Skaria


"Tony Chapman" wrote:

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

year on year tracking
 

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" wrote:

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

year on year tracking
 

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

"Jacob Skaria" wrote:

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")

--
If this post helps click Yes
---------------
Jacob Skaria


"Tony Chapman" wrote:

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

year on year tracking
 

many thanks it works out the ages brilliantly

"Eduardo" wrote:

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" wrote:

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