Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 9 of 9

Thread: age

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Harry Nijholt
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I try to make a simple sheet to determine the age of a person. However when the year of birth is '73, '77, or '81 I do not get the right age, but 1 year less.(only when the day and month are the same)
    fi. born 24-02-1973. Today ia 24-02-2002.
    Formula calculates 28 must be 29.

    Because I have to use the age for another formula I use the following formula
    Right(YEAR(TODAY()-(G2-1));2)+0 WHERE
    G2 is the date of birth.
    Can somebody help me??

    Harry

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-02-24 09:00, nijholt wrote:
    I try to make a simple sheet to determine the age of a person. However when the year of birth is '73, '77, or '81 I do not get the right age, but 1 year less.(only when the day and month are the same)
    fi. born 24-02-1973. Today ia 24-02-2002.
    Formula calculates 28 must be 29.

    Because I have to use the age for another formula I use the following formula
    Right(YEAR(TODAY()-(G2-1));2)+0 WHERE
    G2 is the date of birth.
    Can somebody help me??

    Harry
    Both

    =YEARFRAC(A1,TODAY())

    and

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

    give 29. A1 holds the birthdate you mentioned.

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Harry Nijholt
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the respons.
    I have a dutch version of Excel.
    Do you also have the dutch code?
    Now I get the respond #NAAM?

    Harry

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-02-24 10:00, nijholt wrote:
    Thanks for the respons.
    I have a dutch version of Excel.
    Do you also have the dutch code?
    Now I get the respond #NAAM?

    Harry
    Now, you got me. I don't have the Dutch version at home, not even at school! Try to find YEARFRAC in Index using 'jaar' as keyword, DATEDIF with 'datum'. There must be also some site where all functions are listed in different languages.


  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Harry Nijholt
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey Thanks,

    Jaar.... is not there, however Datumverschil is and it's the solution to my problem.

    Thanks for helping out.

    Harry

  6. #6
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-02-24 12:04, nijholt wrote:
    Hey Thanks,

    Jaar.... is not there, however Datumverschil is and it's the solution to my problem.

    Thanks for helping out.

    Harry
    Mooi zo.

  7. #7
    New Member
    Join Date
    Feb 2002
    Location
    Harry Nijholt
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hallo dan,

    Dat maakt de communicatie een stukje makkelijker. Ben nog even doorgegaan met zoeken en er is ook een JAAR.DEEL
    Alleen moet dan de Invoegtoepassing ANALYSIS Toolpac worden aangezet.

    Moet eerlijk zijn. Daar snap ik nog niet alles van.

    Nogmaals bedankt
    Harry

  8. #8
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,063
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    On 2002-02-24 12:59, nijholt wrote:
    Hallo dan,

    Dat maakt de communicatie een stukje makkelijker. Ben nog even doorgegaan met zoeken en er is ook een JAAR.DEEL
    Alleen moet dan de Invoegtoepassing ANALYSIS Toolpac worden aangezet.

    Moet eerlijk zijn. Daar snap ik nog niet alles van.

    Nogmaals bedankt
    Harry
    Die functie is YEARFRAC. Je kunt daarover beschikken door Analysis Toolpak toe te voegen via Tools|Add-ins (het is Opties, geloof ik).


  9. #9
    New Member
    Join Date
    Feb 2002
    Location
    Harry Nijholt
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Je hebt gelijk.
    Invoegtoepassingen in menu extra.
    Ik heb het toegevoegd en als je de uitkomst dan op getal zet zonder decimalen.....bingo het werkt.

    Bedankt en tot een mogelijke volgende keer.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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