+ Reply to Thread
Results 1 to 117 of 117

Calculating Age

  1. #1
    devinm21
    Guest

    Calculating Age

    If I have a person's birthday, how can I calculate their current age based on
    today's date?


    Thanks!


  2. #2
    Chip Pearson
    Guest

    Re: Calculating Age

    You can use the DATEDIF function. E.g.,

    =DATEDIF(birthdate,TODAY(),"y")

    See www.cpearson.com/excel/datedif.htm for more information about
    DATEDIF.


    --
    Cordially,
    Chip Pearson
    Microsoft MVP - Excel
    Pearson Software Consulting, LLC
    www.cpearson.com



    "devinm21" <[email protected]> wrote in message
    news:[email protected]...
    > If I have a person's birthday, how can I calculate their
    > current age based on
    > today's date?
    >
    >
    > Thanks!
    >




  3. #3
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  4. #4
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  5. #5
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  6. #6
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  7. #7
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  8. #8
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  9. #9
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  10. #10
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  11. #11
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  12. #12
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  13. #13
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  14. #14
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  15. #15
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  16. #16
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  17. #17
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  18. #18
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  19. #19
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  20. #20
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  21. #21
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  22. #22
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  23. #23
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  24. #24
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  25. #25
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  26. #26
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  27. #27
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  28. #28
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  29. #29
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  30. #30
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  31. #31
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  32. #32
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  33. #33
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  34. #34
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  35. #35
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  36. #36
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  37. #37
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  38. #38
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  39. #39
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  40. #40
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  41. #41
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  42. #42
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  43. #43
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  44. #44
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  45. #45
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  46. #46
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  47. #47
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  48. #48
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  49. #49
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  50. #50
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  51. #51
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  52. #52
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  53. #53
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  54. #54
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  55. #55
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  56. #56
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  57. #57
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  58. #58
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  59. #59
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  60. #60
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  61. #61
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  62. #62
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  63. #63
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  64. #64
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  65. #65
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  66. #66
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  67. #67
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  68. #68
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  69. #69
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  70. #70
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  71. #71
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  72. #72
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  73. #73
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  74. #74
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  75. #75
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  76. #76
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  77. #77
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  78. #78
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  79. #79
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  80. #80
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  81. #81
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  82. #82
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  83. #83
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  84. #84
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  85. #85
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  86. #86
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  87. #87
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  88. #88
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  89. #89
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  90. #90
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  91. #91
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  92. #92
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  93. #93
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  94. #94
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  95. #95
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  96. #96
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  97. #97
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  98. #98
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  99. #99
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  100. #100
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  101. #101
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  102. #102
    ertug
    Guest

    RE: Calculating Age



    "devinm21" wrote:

    > If I have a person's birthday, how can I calculate their current age based on
    > today's date?
    >
    >
    > Thanks!
    >


  103. #103
    Vic Sowers
    Guest

    Re: Calculating Age


    "ertug" <[email protected]> wrote in message
    news:[email protected]...
    >
    >
    > "devinm21" wrote:
    >
    >> If I have a person's birthday, how can I calculate their current age
    >> based on
    >> today's date?
    >>
    >>
    >> Thanks!
    >>


    In whole years:

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),1,IF(DAY(NOW())<DAY(A1),1,0)))



  104. #104
    Mangesh Yadav
    Guest

    Re: Calculating Age

    There's been a big discussion on this already.

    http://excelforum.com/showthread.php...light=bluenose

    Mangesh



    "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    news:[email protected]...
    >
    > "ertug" <[email protected]> wrote in message
    > news:[email protected]...
    > >
    > >
    > > "devinm21" wrote:
    > >
    > >> If I have a person's birthday, how can I calculate their current age
    > >> based on
    > >> today's date?
    > >>
    > >>
    > >> Thanks!
    > >>

    >
    > In whole years:
    >
    >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    1,IF(DAY(NOW())<DAY(A1),1,0)))
    >
    >




  105. #105
    Ron Rosenfeld
    Guest

    Re: Calculating Age

    On Thu, 9 Jun 2005 04:54:09 -0500, "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com>
    wrote:

    >
    >"ertug" <[email protected]> wrote in message
    >news:[email protected]...
    >>
    >>
    >> "devinm21" wrote:
    >>
    >>> If I have a person's birthday, how can I calculate their current age
    >>> based on
    >>> today's date?
    >>>
    >>>
    >>> Thanks!
    >>>

    >
    >In whole years:
    >


    Somewhat shorter formula:

    =DATEDIF(A1,TODAY(),"y")


    --ron

  106. #106
    junepbug
    Guest

    Re: Calculating Age

    My version of Excel does not have the "DATEIF" function. I was bale to cut
    and paste the formula in, and it works fine. However it dispays the results
    as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    (##.##) number, which made finding the average age eay. Any suggestions on
    how to get that format back?

    "Mangesh Yadav" wrote:

    > There's been a big discussion on this already.
    >
    > http://excelforum.com/showthread.php...light=bluenose
    >
    > Mangesh
    >
    >
    >
    > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > news:[email protected]...
    > >
    > > "ertug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > >
    > > >
    > > > "devinm21" wrote:
    > > >
    > > >> If I have a person's birthday, how can I calculate their current age
    > > >> based on
    > > >> today's date?
    > > >>
    > > >>
    > > >> Thanks!
    > > >>

    > >
    > > In whole years:
    > >
    > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > >
    > >

    >
    >
    >


  107. #107
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Then you simply need to subtract the earlier date from the recent, and
    format as number.
    =A1-B1

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > and paste the formula in, and it works fine. However it dispays the

    results
    > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > (##.##) number, which made finding the average age eay. Any suggestions on
    > how to get that format back?
    >
    > "Mangesh Yadav" wrote:
    >
    > > There's been a big discussion on this already.
    > >
    > > http://excelforum.com/showthread.php...light=bluenose
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > news:[email protected]...
    > > >
    > > > "ertug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > >
    > > > > "devinm21" wrote:
    > > > >
    > > > >> If I have a person's birthday, how can I calculate their current

    age
    > > > >> based on
    > > > >> today's date?
    > > > >>
    > > > >>
    > > > >> Thanks!
    > > > >>
    > > >
    > > > In whole years:
    > > >
    > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > >
    > > >

    > >
    > >
    > >




  108. #108
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  109. #109
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  110. #110
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  111. #111
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  112. #112
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  113. #113
    junepbug
    Guest

    Re: Calculating Age

    It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change the
    formating but it's not coming up correctly. Is there anything else I can do?

    "Mangesh Yadav" wrote:

    > Then you simply need to subtract the earlier date from the recent, and
    > format as number.
    > =A1-B1
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > My version of Excel does not have the "DATEIF" function. I was bale to cut
    > > and paste the formula in, and it works fine. However it dispays the

    > results
    > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > (##.##) number, which made finding the average age eay. Any suggestions on
    > > how to get that format back?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > There's been a big discussion on this already.
    > > >
    > > > http://excelforum.com/showthread.php...light=bluenose
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > news:[email protected]...
    > > > >
    > > > > "ertug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > >
    > > > > > "devinm21" wrote:
    > > > > >
    > > > > >> If I have a person's birthday, how can I calculate their current

    > age
    > > > > >> based on
    > > > > >> today's date?
    > > > > >>
    > > > > >>
    > > > > >> Thanks!
    > > > > >>
    > > > >
    > > > > In whole years:
    > > > >
    > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > >
    > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  114. #114
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Could you post your data.
    And the formula you are using.

    Mangesh



    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    the
    > formating but it's not coming up correctly. Is there anything else I can

    do?
    >
    > "Mangesh Yadav" wrote:
    >
    > > Then you simply need to subtract the earlier date from the recent, and
    > > format as number.
    > > =A1-B1
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > My version of Excel does not have the "DATEIF" function. I was bale to

    cut
    > > > and paste the formula in, and it works fine. However it dispays the

    > > results
    > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > (##.##) number, which made finding the average age eay. Any

    suggestions on
    > > > how to get that format back?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > There's been a big discussion on this already.
    > > > >
    > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > news:[email protected]...
    > > > > >
    > > > > > "ertug" <[email protected]> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > >
    > > > > > > "devinm21" wrote:
    > > > > > >
    > > > > > >> If I have a person's birthday, how can I calculate their

    current
    > > age
    > > > > > >> based on
    > > > > > >> today's date?
    > > > > > >>
    > > > > > >>
    > > > > > >> Thanks!
    > > > > > >>
    > > > > >
    > > > > > In whole years:
    > > > > >
    > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > >
    > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  115. #115
    junepbug
    Guest

    Re: Calculating Age

    =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    months, " & DATEDIF(I2,(H2),"md") & " days"

    In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    other way doesn't return an age.
    There was a way to do a "yearif" formula, however since I have had an
    upgrade I cannot find that formula. The "yearif" returned 31.50.

    Thanks!

    "Mangesh Yadav" wrote:

    > Could you post your data.
    > And the formula you are using.
    >
    > Mangesh
    >
    >
    >
    > "junepbug" <[email protected]> wrote in message
    > news:[email protected]...
    > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to change

    > the
    > > formating but it's not coming up correctly. Is there anything else I can

    > do?
    > >
    > > "Mangesh Yadav" wrote:
    > >
    > > > Then you simply need to subtract the earlier date from the recent, and
    > > > format as number.
    > > > =A1-B1
    > > >
    > > > Mangesh
    > > >
    > > >
    > > >
    > > > "junepbug" <[email protected]> wrote in message
    > > > news:[email protected]...
    > > > > My version of Excel does not have the "DATEIF" function. I was bale to

    > cut
    > > > > and paste the formula in, and it works fine. However it dispays the
    > > > results
    > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four digit
    > > > > (##.##) number, which made finding the average age eay. Any

    > suggestions on
    > > > > how to get that format back?
    > > > >
    > > > > "Mangesh Yadav" wrote:
    > > > >
    > > > > > There's been a big discussion on this already.
    > > > > >
    > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > >
    > > > > > Mangesh
    > > > > >
    > > > > >
    > > > > >
    > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > news:[email protected]...
    > > > > > >
    > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > >
    > > > > > > > "devinm21" wrote:
    > > > > > > >
    > > > > > > >> If I have a person's birthday, how can I calculate their

    > current
    > > > age
    > > > > > > >> based on
    > > > > > > >> today's date?
    > > > > > > >>
    > > > > > > >>
    > > > > > > >> Thanks!
    > > > > > > >>
    > > > > > >
    > > > > > > In whole years:
    > > > > > >
    > > > > > >
    > > > > >
    > > >

    > =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > >
    > > > > > >
    > > > > >
    > > > > >
    > > > > >
    > > >
    > > >
    > > >

    >
    >
    >


  116. #116
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Ok. So you are looking for the YEARFRAC function.

    =YEARFRAC(I2,H2)

    which returns 31.5


    Mangesh




    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




  117. #117
    Mangesh Yadav
    Guest

    Re: Calculating Age

    Forgot to mention that you need the Analysis Toolpak to use the YEARFRAC
    function.

    Mangesh


    "junepbug" <[email protected]> wrote in message
    news:[email protected]...
    > =DATEDIF(I2,(H2),"y") & " years, " & DATEDIF(I2,(H2),"ym") & "
    > months, " & DATEDIF(I2,(H2),"md") & " days"
    >
    > In this case I2 = 11/2/1964 and H2 = 5/2/1996. Formatting cells as a 2
    > decimal place number fills in "31 years, 6 months, 0 days". Formatting any
    > other way doesn't return an age.
    > There was a way to do a "yearif" formula, however since I have had an
    > upgrade I cannot find that formula. The "yearif" returned 31.50.
    >
    > Thanks!
    >
    > "Mangesh Yadav" wrote:
    >
    > > Could you post your data.
    > > And the formula you are using.
    > >
    > > Mangesh
    > >
    > >
    > >
    > > "junepbug" <[email protected]> wrote in message
    > > news:[email protected]...
    > > > It comes up as 5545 instead of 58 yrs,7 mos. (58.58). I tried to

    change
    > > the
    > > > formating but it's not coming up correctly. Is there anything else I

    can
    > > do?
    > > >
    > > > "Mangesh Yadav" wrote:
    > > >
    > > > > Then you simply need to subtract the earlier date from the recent,

    and
    > > > > format as number.
    > > > > =A1-B1
    > > > >
    > > > > Mangesh
    > > > >
    > > > >
    > > > >
    > > > > "junepbug" <[email protected]> wrote in message
    > > > > news:[email protected]...
    > > > > > My version of Excel does not have the "DATEIF" function. I was

    bale to
    > > cut
    > > > > > and paste the formula in, and it works fine. However it dispays

    the
    > > > > results
    > > > > > as Xyears, Xmonths, Xdays. I used to have it displayed as a four

    digit
    > > > > > (##.##) number, which made finding the average age eay. Any

    > > suggestions on
    > > > > > how to get that format back?
    > > > > >
    > > > > > "Mangesh Yadav" wrote:
    > > > > >
    > > > > > > There's been a big discussion on this already.
    > > > > > >
    > > > > > > http://excelforum.com/showthread.php...light=bluenose
    > > > > > >
    > > > > > > Mangesh
    > > > > > >
    > > > > > >
    > > > > > >
    > > > > > > "Vic Sowers" <Mail@Vic_NOSPAM_Sowers.com> wrote in message
    > > > > > > news:[email protected]...
    > > > > > > >
    > > > > > > > "ertug" <[email protected]> wrote in message
    > > > > > > > news:[email protected]...
    > > > > > > > >
    > > > > > > > >
    > > > > > > > > "devinm21" wrote:
    > > > > > > > >
    > > > > > > > >> If I have a person's birthday, how can I calculate their

    > > current
    > > > > age
    > > > > > > > >> based on
    > > > > > > > >> today's date?
    > > > > > > > >>
    > > > > > > > >>
    > > > > > > > >> Thanks!
    > > > > > > > >>
    > > > > > > >
    > > > > > > > In whole years:
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > >

    > >

    =YEAR(NOW())-YEAR(A1)-IF(MONTH(NOW())>MONTH(A1),0,IF(MONTH(NOW())>MONTH(A1),
    > > > > > > 1,IF(DAY(NOW())<DAY(A1),1,0)))
    > > > > > > >
    > > > > > > >
    > > > > > >
    > > > > > >
    > > > > > >
    > > > >
    > > > >
    > > > >

    > >
    > >
    > >




+ 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