With the DoB in A1 try:

=DATEDIF(A1,TODAY(),"y")

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Emiller" wrote in message
...
What formula can I use to calculate a person age.

We have the current date on the worksheet as well as a column for the
birthdates. Both areas is formatted in a date format. We want a column
that will calculate the persons age as of today.
Any direction would be greatly appreciated.

Em