Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2008
    Location
    Albuquerque, New Mexico, USA
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How can I tell how old someone is from two dates? So if I enter 1/4/1966 in A1 and enter 1/1/2010 in A2, in Cell A3 I want it to be able to tell me that I am 43...just 3 days shy of 44. I used the Year function but that does not calculate the month and day, therefore it says 44. I am sure there is an easy formula...can anyone help me?
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Depending on the degree of precision needed, this should work .....
    =INT((B2-B1)/365.25)

    How accurate do you need to be?
    This formula yields pretty accurate results but it isn't infallible. Dividing by the average number of days in a year works for most people most of the time, but sometimes it gets it wrong. Supposing the person in question is a child, who hasn't yet lived through a 366 day year, you should be dividing by 365 and not 365.25.

    If more precision is needed, we can give a longer formula.

    Here is another short formula ....
    =DATEDIF(B1,B2,"y")
    For some reason, Microsoft has decided not to document this function in any other versions. DATEDIF is treated as the drunk cousin of the Formula family. Excel knows it lives a happy and useful life, but will not speak of it in polite conversation.
    Do not confuse the DATEDIF worksheet function with the DateDiff VBA function.

  3. #3
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Here are a couple of links for DATEDIF function ....

    Introduction To The DATEDIF Function

    DateDif - An Excel's Age Calculator

Posting Permissions

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