Rounding up when I don't want it to.

[Cass]

I am trying to display a calculated age in the column,
but it automatically rounds the age up if I don't show at
least one decimal place.
How do I format the column cells so that it just shows
the number to the left of the decimal place, without
rounding up? I just want it to drop everything to the
right of the decimal place so it is showing the precise
amount. Please help!

 

[Frank Kabel]

Hi
use the formula
=INT(Your_formula)

 

[Guest]

For some reason that is not working. This is how I have
the formula setup:
=INT(CurrentDate-$M13)/365

 

[Guest]

Nevermind, it works! Thanks a lot Frank from Germany!

 

[Frank Kabel]

Hi
use
=INT((CurrentDate-$M13)/365)

 

[Myrna Larson]

You've got your rounding problem solved, but you haven't really solved the
problem of calculating age. Some years have 366 days, other 365. Using 365 as
the divisor produces errors with the date is close to the birthday, and the
older the person it, the greater the error.

You can use

=DATEDIF(A1,TODAY(),"y")

to calculate the person's current age when the date of birth is in A1.