[EpiData-list] Calculating age

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Tue Nov 24 01:22:29 CST 2009


Hello, I have a little problam calculating intervals like age from 
two dates using formula 

 



         LET AGE=ROUND(INT(TODAY-DOB)/365.25)





It returns the value rounded to the nearest whole number, which is a
problem in records of people with birthday 6 and more months (183 
days and more) from today's date, as it makes them one year older.. 
Is there any way to get result rounded towards zero? 

 

Kind regards

Eva 











More information about the EpiData-list mailing list