Calculating the difference between ages in months and years

  • Thread starter Thread starter Charlie157
  • Start date Start date
C

Charlie157

Hi,

I was wondering if anyone could help.

I would like to enter and then calculate the difference in years and
months between a childs age and their reading age.

Is there anyway a number format could be set up for data in years and
months and then could one cell be subtracted from another using a
simple formula?

Is there a better way to acheive the same result?

Hope this is clear, many thanks for any help you can give me.

All the best.
 
Hi i used this formula when i wanted to calculate the difference in days
months and years up to todays date.
=DATEDIF(E5,TODAY(),"y") & " years, " & DATEDIF(E5,TODAY(),"ym") & " months,
" &DATEDIF(E5,TODAY(),"md") & " days"
this is where E5 contained the start date. I also calculated the diference
between two dates by changing TODAY to a refered cell. Hope this helps.
jim
 
Back
Top