Calculate differences between age

C

carlharris

I have a spreadsheet and I want to have ages in a YY: MM format (excel
doesnt like that, any help would be great). eg. 11:08 is 11 years and 8
months.

I will have an actual age for every entry and then a reading age in the
same format for every entry. I will then calculate the difference and
put them in order of the highest difference.

I basically need to know the formula for the format I want to use as my
efforts have not come to fruition as yet!

Thank you in advance, this is a great little community by the looks of
it!

Carl
 
R

Ron de Bruin

Hi carlharris

With the date in A2
This will also work if it is negative

=IF(A2<=TODAY(),DATEDIF(A2,TODAY(),"Y") & " y " & DATEDIF(A2,TODAY(),"ym") & " m","-"&DATEDIF(TODAY(),A2,"y")& " y "
&DATEDIF(TODAY(),A2,"ym")& " m")

With DateRefiner you can insert this formula in your data table if you want
http://www.rondebruin.nl/datarefiner.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating age differences 6
Calculate Age 2
age calculations 2
Calculating age 1
Calculate age 3
date of birth age formula 8
How do I calculate a person's age from date of birth and a date 2
excel formula sumproduct and age ranges 3

Top