I have a sheet where I calculate someone's age exactly using YEARFRAC and pass this to various other formulae. I want to force this to round down without affecting the value (since this adds a rounding error to later calucluations) - if you are 20.6 years old, you would say you were 20 not 21 so this is what I want to see. Is there any way I can do this as ROUNDDOWN and DATEDIF both return integer values only and formatting would round this up?
Bookmarks