View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eddie O
 
Posts: n/a
Default How can I get an age using todays date and date of birth?

assuming the birthdate is in cell A1
=YEAR(NOW())-YEAR(A1)

"tjw1313" wrote:

I'm using a spreadsheet where I need ages listed. Is there a formula that
can be used to compute the age if I use todays date and date of birth? So
far I am not having any luck. Thanks for any help you may provide. I am
using Excel 2000.