Why do you throw up a solution that you KNOW to be absolutely incorrect.

Not only is it incorrect but correct solutions have been posted
almost an hour before yours. If you are a company, that
certainly is not good advertising.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bill Ridgeway" wrote in message ...
Try the formula -
=(TODAY()-A1)/365 (where the date of birth is in A1)
It is not absolutely accurate as it does not take account of leap years but
may be good enough.

Regards.

Bill Ridgeway
Computer Solutions

"brenner" wrote in message
...
using todays date what formula do i use to calculate a person age using
their
date of birth