How to Round Down

[mykrobinson]

I have an expression to calculate a person's age based on today minus the birthday:

Number(HOUR(TODAY()-[DOB])/365.25/24)&" yr"

I am finding expressions for rounding up, but how do I get it to always round down until the birthday has actually passed? I had an entry today that shows the person to be 75 years old, but they are still 74 for another week.

Thanks

[Joseph_Seddik]

FLOOR() | AppSheet Help Center 

[mykrobinson]

I previously was using floor, but it still tends to round up. I don't see an option with floor, ceiling, or number to force it to always round down, these three options seem to produce the same result 🤔

[Joseph_Seddik · Accepted solution]

You must have had problems elsewhere.

[mykrobinson]

You are correct, i had a math problem. I initially was using 365 in the expression, but adjusted it to 365.25 to account for leap year, and now floor is working as it should. Thank you!