age on a employee list spreadsheet

[FF Maria]

I would like to know what formula to use to read a date of birth, compare it to the computers date and give and age in years in another column. Can you help me???

 

[Aladin Akyurek]

On 2002-03-16 09:30, FF Maria wrote:
I would like to know what formula to use to read a date of birth, compare it to the computers date and give and age in years in another column. Can you help me???

=DATEDIF(A1,TODAY(),"Y")

or

=YEARFRAC(A1,TODAY())

The second requires the Analysis Toolpak which can be added, if not installed, via Tools|Add-Ins.

Aladin

 

[Paul-Johnson]

assume b2 has the date of birth

in cell c2 enter this formula and format the cell as number with 1 decimal point

=(NOW()-B3)/365

_________________
Paul
This message was edited by Paul-Johnson on 2002-03-16 10:03