ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Age Calculation (https://www.excelbanter.com/excel-worksheet-functions/120365-age-calculation.html)

Annie

Age Calculation
 
Hi
I remember calclating someones age before in Excel 97 but have forgotten the
formula. =now()-birthdate or something similar.
Can someone help me?

Many thanks
--
Kind regards

Ann Shaw

Stefi

Age Calculation
 
Make a search in this forum with words Age Calculation!

Regards,
Stefi

€žAnnie€ť ezt Ă*rta:

Hi
I remember calclating someones age before in Excel 97 but have forgotten the
formula. =now()-birthdate or something similar.
Can someone help me?

Many thanks
--
Kind regards

Ann Shaw


Paul B

Age Calculation
 
Ann, have a look here,

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

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Annie" wrote in message
...
Hi
I remember calclating someones age before in Excel 97 but have forgotten

the
formula. =now()-birthdate or something similar.
Can someone help me?

Many thanks
--
Kind regards

Ann Shaw





All times are GMT +1. The time now is 04:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com