ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Caculate Age (https://www.excelbanter.com/excel-worksheet-functions/6489-caculate-age.html)

John

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





All times are GMT +1. The time now is 09:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com