Calculating age of individual
 

How can I display the name of an individual in a given cell. In cell A1
I have today's date; =today(). In cell A2 I have individual's date of
birth; 2/1/60 for example. I cell A3 I want to display the
individual's age - in this example it would be 06/16/06 minus
02/01/1960. should display 46 years old.

Thanks for any comments.


--
maacmaac
------------------------------------------------------------------------
maacmaac's Profile: http://www.excelforum.com/member.php...fo&userid=2959
View this thread: http://www.excelforum.com/showthread...hreadid=553218

Calculating age of individual
 

maacmaac,

You can just take the difference between the two dates, but set the
format for the difference as a "number" and divide that by 365.


--
gonger
------------------------------------------------------------------------
gonger's Profile: http://www.excelforum.com/member.php...o&userid=34797
View this thread: http://www.excelforum.com/showthread...hreadid=553218

Calculating age of individual
 

Or

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & "
months, " & DATEDIF(A1,NOW(),"md") & " days"

from this website


http://www.cpearson.com/excel/datedif.htm


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=553218