formula to automatically calculate customer age

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top