Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
year on year tracking | Excel Discussion (Misc queries) | |||
Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
how to calculate $1000/year at 5% for 25 years showing each year | Setting up and Configuration of Excel | |||
Need to create attendance tracking based on % and 2080 hours/year | Excel Discussion (Misc queries) | |||
How to compare current year to prior year in bar chart? | Charts and Charting in Excel |