Age calculation - formating numbers - rounding

Hi there,

here is a simple question : I used the right formula to calculate the age from a birthday date.
The result, although a integer, is rounded.
In other words, if the result is 52,946, it becomes 53 while it should be 52 until you reach your birthday anniversary…

Thank you

Hi,

You may use ROUNDDOWN() to tune your calculated result:

Thank you Angie. Is there a URL where I could find the language used in Ragic? with examples? Thanks again

Hi,

Are you referring to UI languages? Ragic currently supports English, Chinese (Traditional and Simplified), Japanese, and Spanish. If you would like other custom UI translations, please refer to this document.

Hi Angie, just a related question about age calculation : is it possible to use two formulæ in the same cell or field? like in this case (1) age calculation + (2) Rounddown?
Or is it necessary to hide the calculation cell?

Thanks again

Hi,

Sure, applying formulas like ROUNDDOWN((TODAYTZ()-A1)/365.25,0) to a numeric field could work.

Thanks Angie, I will give it a try!

It works fine!
Thanks again

@Angie What about if I want to take as an answer age: 40 years & 5 Months .
How we can achieve that? Thanks in advance

Hi,

You’ll need 4 fields in total.

A1: Birthday field

A2: “Years” numeric field to calculate the years

``````ROUNDDOWN((TODAYTZ()-A1)/365.25,0)
``````

A3: “Months” numeric field to calculate the months

``````ROUND(((TODAYTZ()-A1)/365.25-A2)*365.25/30,0)
``````

A4: “Answer” free text field to combine values with string formulas

``````A2+" Years & "+A3+" Months"
``````