24 Nov
2009
24 Nov
'09
1:22 a.m.
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