Excel: Age in Months, reading ages, decimals
Suggests puttin years and months in different cells.
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
Still not able to get around the issue, I need a way of telling excel that its dealing with months not numbers to 10
Reading Ages sample.xlsx
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
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
Thanks guys, making progress lol.
I'm going home now, will revisit this on Monday
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.
Can you please help??!
There are currently 1 users browsing this thread. (0 members and 1 guests)