With DOB in A1,
In B1: =DATEDIF(A1,TODAY(),"y")
Format B1 as general
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:19,500 Files:362 Subscribers:62
xdemechanik
---
"bubbles galore" wrote:

I don't seem to understand how to create a formula that will automatically
enter a client's age in years using "TODAY" and their date of birth. I want
it to automatically apply to all entries in the database.
In a previous version (2003?) the formula was =(NOW()-dob)/365. TODAY has
replaced NOW but the formula =(TODAY()-dob) doesn't work.
Can anyone help?