what function converts dob to age

#1 (**permalink**) 28-Jul-2006, 08:22 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11577-what-function-converts-dob-to-age.html
this? Thanks.

*

#2 (**permalink**) 28-Jul-2006, 08:22 AM

"lisa" wrote in message
news:F021276A-A26B-4E4A-ADCF-D936C71D20FF@microsoft.com
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11577
> I am trying to convert date of births to actual ages. I know the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11577
> 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

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)