# How to get the difference between 2 ages in excel ??

• 22nd June 2012, 02:04 PM
pooley
How to get the difference between 2 ages in excel ??
I have been asked to produce a spreadheet that will work out chronological ages and the difference between reading ages and chronological ages in excel, showing -/+ values.

Now as months got to 12 and not 10 excel is not playing ball, and I've got that Friday feeling where my brain doesn't function too well.

Anyone fancy a look for me?

I need the difference in months between columns I and H.Attachment 14403

Cheers

Si
• 22nd June 2012, 02:15 PM
plexer
Excel: Age in Months, reading ages, decimals

Suggests puttin years and months in different cells.

Ben
• 22nd June 2012, 02:23 PM
pooley
Still not able to get around the issue, I need a way of telling excel that its dealing with months not numbers to 10
• 22nd June 2012, 02:26 PM
pubgrub277
Attachment 14404
you can use =dollarfr to convert numbers into fractions instead of decimals on =dollarde to convert back to deicmal. Ive applied it to reading ages.
Have a look at this as an example and see if it works for you
• 22nd June 2012, 02:32 PM
plexer
Someone trying to do the exact same thing:

Calculate the difference between ages, show as yy mm - ExcelBanter

Ben
• 22nd June 2012, 02:36 PM
plexer
Quote:

Originally Posted by pubgrub277
Attachment 14404
you can use =dollarfr to convert numbers into fractions instead of decimals on =dollarde to convert back to deicmal. Ive applied it to reading ages.
Have a look at this as an example and see if it works for you

Looks like it does the job, could do with some contraints on what you can enter though.

Ben
• 22nd June 2012, 03:05 PM
pooley
Attachment 14405
@pubgrub277 thanks mate, nearly got it working, i've edited it so it works out the chronological age of the child based on the date of the test taken and dob. But it's not shoing the months only the year difference. Now after working on this for a few hours I can no longer see the wood for the trees, can you spot my obvious mistake, because i Bl00*y can't :(

Si
• 22nd June 2012, 03:38 PM
pubgrub277
• 22nd June 2012, 03:58 PM
mac_shinobi
• 22nd June 2012, 04:00 PM
pooley
Thanks guys, making progress lol.

I'm going home now, will revisit this on Monday

Si
• 25th June 2012, 02:08 PM
pooley
Attachment 14415

Thanks guys, took your advice and examples and along with another forum for help I have it working.

Have attached document in case someone else wants the formula

Si
• 19th March 2013, 10:01 AM
mkitchen
Hi.

Im actually looking for a less complicated version of this. I just have two coloums of ages (that are entered manually) and I want to know the differences between the two ages. There are no DOB coloums or date of test coloums.