age on a employee list spreadsheet

FF Maria · Mar 16th, 2002, 10:30 AM

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 · Mar 16th, 2002, 10:34 AM

Quote:

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 · Mar 16th, 2002, 10:56 AM

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 ]

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

Mar 16th, 2002, 10:30 AM	#1
FF Maria New Member Join Date: Mar 2002 Posts: 1	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???

Mar 16th, 2002, 10:56 AM	#3
Paul-Johnson New Member Join Date: Feb 2002 Posts: 47	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 ]