• XL Date Formula

    • This topic has 5 replies, 6 voices, and was last updated 24 years ago.
    Author
    Topic
    #355884

    Does anyone know how to use XL’s date formula to determine the exact age of someone. As an example:

    Birthdate: 01/01/00
    Today’s Date: 05/31/01
    Calculated Age = 1.4166

    I’m trying to utilize the date formula for benefit calculations.

    Viewing 2 reply threads
    Author
    Replies
    • #525780

      Hi
      This is crude but it may work for you

      Assume Birthday in a1
      Calc Age in a2 with

      =(today()-a1)/365

      You will need to format A2 a number, say two decimal places.
      There are far more sophisticated calculations about.

      Cheers
      Geof

    • #525810

      If the birth date is in A1, then:

      =(Today() - A1) / 365.25
      
      • #525820

        You can also use =DATEDIF(A1,today(),”d”)/365.25 alien

        • #525830

          I don’t like the approximation here- and it can give “not quite” the right answer. But your post prompted me to come up with:
          =DATEDIF(A1,NOW(),”Y”)

          But the help on DATEDIF says that it’s included only for compatibility with Excel. So there must be another function somewhere?

    • #525854

      hi,
      I use this one to give an accurate age. (in the example A6 is the birthdate)

      =DATEDIF(A6,NOW(),”y”) & “y, “& DATEDIF(A6,NOW(),”ym”)&”m, “& DATEDIF(A6,NOW(),”md”) & “d”

      This displays as: 43y, 0m, 16d

      HTH

      Regards
      Farside

    Viewing 2 reply threads
    Reply To: XL Date Formula

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: