### [Solved] Stop rounding up in age within a formula

Posted:

**Fri May 03, 2019 4:11 pm**I have a horse racing spreadsheet and I have the age of the horse, for any particular race, calculated by its DOB and the race date, in single years. I also have a 2nd column next to it showing the age of the horse to 2 decimal points.

Both cells have this formula =(A7-Q7)/365.25). (A is the race date and Q is the DOB).

What I see is that when the age of the horse goes beyond half a year in the 2nd column (so after .49), the age is rounded up in the column of single years. I don't want this to happen, so how do I stop the rounding up?

Both cells have this formula =(A7-Q7)/365.25). (A is the race date and Q is the DOB).

What I see is that when the age of the horse goes beyond half a year in the 2nd column (so after .49), the age is rounded up in the column of single years. I don't want this to happen, so how do I stop the rounding up?