+ Post New Thread
Results 1 to 12 of 12
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. #1
    pooley's Avatar
    Join Date
    Sep 2005
    Location
    S Wales
    Posts
    1,129
    Thank Post
    77
    Thanked 118 Times in 99 Posts
    Rep Power
    66

    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. #2

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,331
    Thank Post
    622
    Thanked 1,578 Times in 1,415 Posts
    Rep Power
    413
    Excel: Age in Months, reading ages, decimals

    Suggests puttin years and months in different cells.

    Ben

  3. #3
    pooley's Avatar
    Join Date
    Sep 2005
    Location
    S Wales
    Posts
    1,129
    Thank Post
    77
    Thanked 118 Times in 99 Posts
    Rep Power
    66
    Still not able to get around the issue, I need a way of telling excel that its dealing with months not numbers to 10

  4. #4
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    81
    Thank Post
    3
    Thanked 17 Times in 10 Posts
    Rep Power
    17
    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

  5. Thanks to pubgrub277 from:

    pooley (22nd June 2012)

  6. #5

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,331
    Thank Post
    622
    Thanked 1,578 Times in 1,415 Posts
    Rep Power
    413
    Someone trying to do the exact same thing:

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

    Ben

  7. #6

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,331
    Thank Post
    622
    Thanked 1,578 Times in 1,415 Posts
    Rep Power
    413
    Quote Originally Posted by pubgrub277 View Post
    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
    Looks like it does the job, could do with some contraints on what you can enter though.

    Ben

  8. #7
    pooley's Avatar
    Join Date
    Sep 2005
    Location
    S Wales
    Posts
    1,129
    Thank Post
    77
    Thanked 118 Times in 99 Posts
    Rep Power
    66
    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. #8
    pubgrub277's Avatar
    Join Date
    Jul 2010
    Location
    Newcastle
    Posts
    81
    Thank Post
    3
    Thanked 17 Times in 10 Posts
    Rep Power
    17

  10. Thanks to pubgrub277 from:

    pooley (22nd June 2012)

  11. #9

    mac_shinobi's Avatar
    Join Date
    Aug 2005
    Posts
    9,705
    Thank Post
    3,239
    Thanked 1,045 Times in 967 Posts
    Rep Power
    363

  12. #10
    pooley's Avatar
    Join Date
    Sep 2005
    Location
    S Wales
    Posts
    1,129
    Thank Post
    77
    Thanked 118 Times in 99 Posts
    Rep Power
    66
    Thanks guys, making progress lol.

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

    Si

  13. #11
    pooley's Avatar
    Join Date
    Sep 2005
    Location
    S Wales
    Posts
    1,129
    Thank Post
    77
    Thanked 118 Times in 99 Posts
    Rep Power
    66
    Reading Ages final.xlsx

    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

  14. #12

    Join Date
    Mar 2013
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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.

    Can you please help??!

    thanks

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 3
    Last Post: 18th May 2011, 02:11 PM
  2. how to track the chat log/ pm in fronter?
    By lionsl2005 in forum Virtual Learning Platforms
    Replies: 4
    Last Post: 5th April 2011, 12:42 PM
  3. Replies: 9
    Last Post: 30th October 2009, 01:46 PM
  4. how to get the it department to do their actual job
    By stevenlong1985 in forum Other Stuff
    Replies: 6
    Last Post: 21st July 2009, 09:54 AM
  5. Replies: 8
    Last Post: 11th April 2006, 11:55 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •