View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
maacmaac
 
Posts: n/a
Default 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