How to calculate age?

  • excelconsulting
    Asked on February 22, 2016 at 1:04 PM

    Hi!

    The above provided example does not provide an accurate answer. For instance, if I set the birth date to 24 Feb 1998, it gives an age of 18, which I will only reach after 2 days..

     

    Any solution to this?

  • Kevin Support Team Lead
    Replied on February 22, 2016 at 1:22 PM

    This is because the Form Calculation widget is rounding the value, if you would like to get the exact value, you will need to get the total with decimals. 

    How to calculate age?  Image 1 Screenshot 20

    However, if the birthday is nearly the current day, it seems to be rounding the value. Try testing it and let us know the result.