How do I make the D.O.B. Column calculate in Age Colum in Excel?

G

Gee

I am trying to formulate Column F (Date of Birth) into Column E (Today's Age)
May someone please help me. Thanking you in advance, Gee
 
W

wjohnson

Use the Function NOW() - put it in cell A1, - this gives you the curren
date.
Put your date in cell A2
In cell B2 enter the following formula =(A1-A2)/365
I used the following format for cells A1 and A2 Date Format - 14 ma
98
Then use a "General" Format for Cell B2

This will give you a number with a decimal point - the numbers to th
left of the decimal point = years, to the right will be the months.

Example:
29-Nov-05
16-Jul-47 58.4156001
 
Top