View Single Post
  #3   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?

Actually, I don't think that last formula will work under certain
circumstances. You should check out the DATEDIF formula in excel help. For
the "end date" part of the formula, use TODAY() which will dynamically put
in today's date.

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