what function converts dob to age

G

Guest

I am trying to convert date of births to actual ages. I know the formula is
=INT((E14-B14)/365.25), but it won't let me paste this. How do I actually do
this? Thanks.
 
D

Dirk Goldgar

lisa said:
I am trying to convert date of births to actual ages. I know the
formula is =INT((E14-B14)/365.25), but it won't let me paste this.
How do I actually do this? Thanks.

That formula is not completely accurate, and it looks like an Excel
formula anyway. You posted this in an Access newsgroup; if you're
looking for an Access solution, see this link:

http://www.mvps.org/access/datetime/date0001.htm
Date/Time: Calculate Age of a person
 

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