One way,
with the DOB in A1 and =TODAY() in B1
=(B1-A1)/365.25
Format the cell this is in as Number,
Regards,
Alan
"Pate" wrote in message
...
We are using Excel as a manual log of visits. We would like to screen out
anyone that is not 18 years old and were looking for a means of
calculating
the age from the current date and the date of birth. Is there a function
that
can do this?