calculating age in excel

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

With the DoB in A1 try:

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

--
HTH

Sandy
In Perth, the ancient capital of Scotland

[email protected]
[email protected] with @tiscali.co.uk


"Emiller" <[email protected]> wrote in message
news:[email protected]...
> 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
>