Results 1 to 3 of 3
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Age in Years (2002)

    This HAS to be easy, but I can't find it:

    The birthday is in A1. How do I put the age in years in B1? (It shouldn't increment until the birthday occurs.)
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Age in Years (2002)

    There is an undocumented function, DATEDIF, which should do as you want.

    <big>=DATEDIF(A1,TODAY(),"Y")</big>

    Formore detail see Chip Pearson's description

    Andrew C

  3. #3
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Age in Years (2002)

    That did it!

    I had used the DATEDIF function in Visual Basic, but didn't know of it in Excel.

    Thanks for your help.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Posting Permissions

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