Calculate Age

rookie · Feb 21st, 2002, 09:14 AM

I have a column with Birth Dates and am wondering if Excel can somehow compare it to todays date and populate the resulting age in Years and months in another column

All help is much appreciated

Aladin Akyurek · Feb 21st, 2002, 09:51 AM

It will be a big step forward if the Archives of this board becomes fully searchable. One can easily find the answer to this often-posted question in there.

=DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months

or

=YEARFRAC(TODAY(),A1)

where A1 houses a birth date.

rookie · Feb 21st, 2002, 10:51 AM

Thanks for your help Aladin..

I agree,

The search function enhancement will be a welcome feature

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

Feb 21st, 2002, 09:14 AM	#1
rookie New Member Join Date: Feb 2002 Posts: 2	I have a column with Birth Dates and am wondering if Excel can somehow compare it to todays date and populate the resulting age in Years and months in another column All help is much appreciated

Feb 21st, 2002, 09:51 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,314	It will be a big step forward if the Archives of this board becomes fully searchable. One can easily find the answer to this often-posted question in there. =DATEDIF(A1,TODAY(),"y")&" years, "&DATEDIF(A1,TODAY(),"ym")&" months or =YEARFRAC(TODAY(),A1) where A1 houses a birth date.

Feb 21st, 2002, 10:51 AM	#3
rookie New Member Join Date: Feb 2002 Posts: 2	Thanks for your help Aladin.. I agree, The search function enhancement will be a welcome feature