formula to automatically calculate customer age

  • Thread starter Thread starter bubbles galore
  • Start date Start date
B

bubbles galore

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?
 
Back
Top