Results 1 to 10 of 10

Thread: Excel

  1. #1
    Jakkie
    Guest

    Default Excel

    Can anyone help me? I am working in Excel. I have 35 birthdates of students. I want to work out what is their age e.g. date tested: 2004-10-28 and a birthdate e.g. 1992-03-28. On paper I can deduct their birthday from 2004-01-28, but it take ages to do. Is their a shorter method to do this in Excel?

  2. #2
    godfather
    Guest

    Default Re: Excel

    Just perform arithmetic on the dates in excel.

    2004/10/28 - 1992/03/28 = 4597 (days)

    Divide the days by 365.25 to get years (12.59)

    You need to format the calculated cell as a number, it will assume a date format and give a strange answer until you do.

  3. #3
    parry
    Guest

    Default Re: Excel

    Hi Jakkie, see this site and look for the heading 'Calculating A Person's Age' (about halfway down).

  4. #4
    robo
    Guest

    Default Re: Excel

    Easy. If today's date is in B1 and their birth date is in A1:

    =(B1-A1)/365.25

    Make sure you format the cell as a number (choose Format, Cells, and choose number. If you have two decimal places you will get an answer like 5.85.

    This formula:

    =INT((B1-A1)/365.25)& "years and "&((B1-A1)-INT((B1-A1)/365.25)*365.25)&"days"

    Says "6 years and 278 days" if you want to get really carried away.
    (I would copy this and paste it in to try it out)
    Good luck, teach.
    robo.

  5. #5
    robo
    Guest

    Default Re: Excel

    Holy crap! There were no answers when I started replying to this.
    robo.

  6. #6
    Dolby Digital
    Guest

    Default Re: Excel

    6 mins slower than GF. As you are an accountant by trade is that extra 6 minutes chargable

  7. #7
    Jakkie
    Guest

    Default Excel

    Thanks Godfather and Parry for your quick reply. The website that you recommended Parry, is excellent.

    Jakkie

  8. #8
    Jakkie
    Guest

    Default Re: Excel

    Thanks Robo. This sound much easier. There is hope for me!!

  9. #9
    robo
    Guest

    Default Re: Excel

    Never turn down a chance to charge someone.

    Hear the one about the accountant that died? He got to the Pearly Gates and there were ticker-tape parades, brass bands, God personally welcomed him. He asked if they made this fuss for everyone and God said "You're the oldest person we've had". The Accountant said "But I'm only 56.". God says "That's odd, we added up the time you've done on your timesheets and we figured you were 126!"

    Sorry.
    robo.

  10. #10
    parry
    Guest

    Default Re: Excel

    > Thanks Godfather and Parry for your quick reply. The
    > website that you recommended Parry, is excellent.
    >
    > Jakkie

    Nothing wrong with Godfathers and Robo's advice either, just shows theres usually more than one way to do things. :-)

    Chip Pearson is an Excel MSVP with a lot of good tips and I recommend bookmarking this page.


Similar Threads

  1. Replies: 1
    Last Post: 28-09-2008, 11:35 PM
  2. Excel
    By Tammy in forum PressF1
    Replies: 10
    Last Post: 23-12-2003, 04:52 PM
  3. Excel 97 to Excel 2000 Files
    By Scott Vail in forum PressF1
    Replies: 1
    Last Post: 03-07-2003, 03:26 PM
  4. MS Excel
    By Chris Knaggs in forum PressF1
    Replies: 2
    Last Post: 14-03-2003, 09:13 PM
  5. Excel 2000 & Excel 97 toolbars
    By in forum PressF1
    Replies: 0
    Last Post: 11-06-1999, 08:27 AM

Posting Permissions

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