How do you do....it? Thread, How to get the difference between 2 ages in excel ?? in Technical; I have been asked to produce a spreadheet that will work out chronological ages and the difference between reading ages ...
1. ## 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.jo.xls

Cheers

Si

2. Excel: Age in Months, reading ages, decimals

Suggests puttin years and months in different cells.

Ben

3. Still not able to get around the issue, I need a way of telling excel that its dealing with months not numbers to 10

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

5. ## Thanks to pubgrub277 from:

pooley (22nd June 2012)

6. Someone trying to do the exact same thing:

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

Ben

7. Originally Posted by pubgrub277
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

8. Copy of Reading Ages sample.xlsx
@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

9. ## Thanks to pubgrub277 from:

pooley (22nd June 2012)

10. Thanks guys, making progress lol.

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

Si

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

12. 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.

thanks

SHARE: