Calculate Age

[rookie]

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]

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]

Thanks for your help Aladin..

I agree,

The search function enhancement will be a welcome feature