How to calculate age?

  • Profile Image
    excelconsulting
    Asked on February 22, 2016 at 01: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?

  • Profile Image
    Kevin_G
    Answered on February 22, 2016 at 01: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. 

    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.