Formula for calculating age

jensteve · May 2nd, 2002, 05:37 PM

What is the formula for calculating age in years using date of birth?

sen_edp · May 2nd, 2002, 05:42 PM

hello there

The following formula returns the age of a person whose date of birth you enter in cell A1.

=INT(YEARFRAC(TODAY(),A1,1))

YOU MUST HAVE THE ANALYSIS-TOOLPACK ADDIN INSTALLED!

REGARDS

sen_edp · May 2nd, 2002, 05:50 PM

If you dont want the analysis toolpack installed you can try that too:

=datedif(a1,today(),"Y")

Rgrds

Andreas

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 05:37 PM	#1
jensteve New Member Join Date: May 2002 Posts: 1	What is the formula for calculating age in years using date of birth?

May 2nd, 2002, 05:42 PM	#2
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello there The following formula returns the age of a person whose date of birth you enter in cell A1. =INT(YEARFRAC(TODAY(),A1,1)) YOU MUST HAVE THE ANALYSIS-TOOLPACK ADDIN INSTALLED! REGARDS

May 2nd, 2002, 05:50 PM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	If you dont want the analysis toolpack installed you can try that too: =datedif(a1,today(),"Y") Rgrds Andreas