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.
|