#1   Report Post  
John
 
Posts: n/a
Default Caculate Age

What formula do I use to calculate an age?

I have two cells populated with D.O.B and Current Date. At the moment I just
simply take one from the other and divide by 365, but problem here is that
it rounds the answer, thus someone that is 17.6 is rounded to 18, whereas
they are not 18 until 18 is hit, so to speak

Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"