Try this:

=ROUNDDOWN((TODAY()-A1)/365,0)

A1 is where the Bdate is entered.

HTH,
Paul

"paralegal" wrote in message
...
is there an easy way to do this through a formula? I tried using the year
function and subtracting from current date but is doesn't caluculate
correctly if the birthday hasn't yet occured in current year. Thank you.