+ Reply to Thread
Results 1 to 5 of 5

Function to calculate the number of years, months and days between

  1. #1
    Biff
    Guest

    Re: Function to calculate the number of years, months and days between

    Take a look at this:

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

    Biff

    "Vicky" <[email protected]> wrote in message
    news:[email protected]...
    > Hi,
    > Hope you can help. I am trying to find a Function to calculate the number
    > of years, months and days between 2 dates. Such as to calculate how old
    > someone is down to the day.
    >
    > I have played with the YEARFRAC fx and the following:
    > =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
    >
    > I know I am missing something. Can you help?
    >
    > Thanks so much!
    >




  2. #2
    Vicky
    Guest

    Re: Function to calculate the number of years, months and days bet

    Thank you so much. I think that will do it.

    "Biff" wrote:

    > Take a look at this:
    >
    > http://www.cpearson.com/excel/datedif.htm
    >
    > Biff
    >
    > "Vicky" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hi,
    > > Hope you can help. I am trying to find a Function to calculate the number
    > > of years, months and days between 2 dates. Such as to calculate how old
    > > someone is down to the day.
    > >
    > > I have played with the YEARFRAC fx and the following:
    > > =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
    > >
    > > I know I am missing something. Can you help?
    > >
    > > Thanks so much!
    > >

    >
    >
    >


  3. #3
    Vicky
    Guest

    Function to calculate the number of years, months and days between

    Hi,
    Hope you can help. I am trying to find a Function to calculate the number
    of years, months and days between 2 dates. Such as to calculate how old
    someone is down to the day.

    I have played with the YEARFRAC fx and the following:
    =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)

    I know I am missing something. Can you help?

    Thanks so much!


  4. #4
    Biff
    Guest

    Re: Function to calculate the number of years, months and days between

    Take a look at this:

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

    Biff

    "Vicky" <[email protected]> wrote in message
    news:[email protected]...
    > Hi,
    > Hope you can help. I am trying to find a Function to calculate the number
    > of years, months and days between 2 dates. Such as to calculate how old
    > someone is down to the day.
    >
    > I have played with the YEARFRAC fx and the following:
    > =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
    >
    > I know I am missing something. Can you help?
    >
    > Thanks so much!
    >




  5. #5
    Vicky
    Guest

    Re: Function to calculate the number of years, months and days bet

    Thank you so much. I think that will do it.

    "Biff" wrote:

    > Take a look at this:
    >
    > http://www.cpearson.com/excel/datedif.htm
    >
    > Biff
    >
    > "Vicky" <[email protected]> wrote in message
    > news:[email protected]...
    > > Hi,
    > > Hope you can help. I am trying to find a Function to calculate the number
    > > of years, months and days between 2 dates. Such as to calculate how old
    > > someone is down to the day.
    > >
    > > I have played with the YEARFRAC fx and the following:
    > > =(YEAR(A4)-YEAR(A3))*12+MONTH(A4)-MONTH(A3)
    > >
    > > I know I am missing something. Can you help?
    > >
    > > Thanks so 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