year on year tracking

  • Thread starter Thread starter Tony Chapman
  • Start date Start date
T

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
 
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")
 
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
 
brilliant. thank you very much. calculations of ages are spot on - though i
didn't need the days bit.
 
many thanks it works out the ages brilliantly

Eduardo said:
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
Click to expand...
 
Back
Top