Results 1 to 3 of 3

Thread: Age (E2000)

  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Age (E2000)

    How can I easily find the age of someone by inputing their birthdate?

    Thanks
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Age (E2000)

    If A1 has the birthday, put this in a cell:
    <pre>=DATEDIF(A1,NOW(),"y")</pre>


    Or if you want years, months and days:
    =DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & " months, " & DATEDIF(A1,NOW(),"md") & " days"


    Steve

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,815
    Thanks
    132
    Thanked 479 Times in 456 Posts

    Re: Age (E2000)

    I had to do this once for a hospital.
    It was more tricky than I thought to start with.
    Particularly with newborn babies etc.
    The patient ages ranged from:
    newborn - born today
    x days old (used for ages less than 2 weeks)
    x weeks old (used for ages less than 3 months)
    x months old (used for ages less than 2 years)
    teenager etc.
    The worst problem was patients over 100 years old (honest!)
    Excel wouldn't accept dates before 01-Jan-1900!
    Fortunately, the latter problem gets less and less!
    Good luck with your requirements!
    zeddy

Posting Permissions

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