age

nijholt

New Member
Joined
Feb 23, 2002
Messages
5
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
 

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
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.
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Hey Thanks,

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

Thanks for helping out.

Harry
 
Upvote 0
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
 
Upvote 0
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).
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top