=DATEDIF(DoB,TODAY(),"Y")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

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