what function converts dob to age

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
Click to expand...

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