Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

what function converts dob to age

Discussion in 'Information Technology' started by lisa, Jul 28, 2006.

  1. lisa

    lisa
    Expand Collapse
    Guest

    I am trying to convert date of births to actual ages. I know the formula is
    =INT((E14-B14)/365.25), but it won't let me paste this. How do I actually do
    this? Thanks.
     
  2. Loading...


  3. Dirk Goldgar

    Dirk Goldgar
    Expand Collapse
    Guest

    "lisa" <lisa@discussions.microsoft.com> wrote in message
    news:F021276A-A26B-4E4A-ADCF-D936C71D20FF@microsoft.com
    > I am trying to convert date of births to actual ages. I know the
    > formula is =INT((E14-B14)/365.25), but it won't let me paste this.
    > How do I actually do this? Thanks.


    That formula is not completely accurate, and it looks like an Excel
    formula anyway. You posted this in an Access newsgroup; if you're
    looking for an Access solution, see this link:

    http://www.mvps.org/access/datetime/date0001.htm
    Date/Time: Calculate Age of a person

    --
    Dirk Goldgar, MS Access MVP
    www.datagnostics.com

    (please reply to the newsgroup)
     

Share This Page