+ Reply to Thread
Results 1 to 3 of 3

calculating days between years

  1. #1
    Registered User
    Join Date
    08-08-2007
    Posts
    2

    calculating days between years

    Hi,
    I'm only new to excel and have totally confused myself.Im trying to calculated the days between a persons birth date and the current date.To get the current date I used the =NOW() function but it also gives me the time which i don't wont.This is what i am trying to achieve:

    name birth date current date age (days) age (years)

    john 12/11/1980 8/9/2007 ??? ???

    assume 1 year = 365.25 days

    any help would be appreciated

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    calculating days between years

    See Chip Pearson's coverage of Excel's undocumented DATEDIF function:

    http://www.cpearson.com/excel/datedif.htm

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

  3. #3
    Registered User
    Join Date
    08-08-2007
    Posts
    2
    That was exactly what I was after.Strange that it was not listed under the insert function menu.. Thanks very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1