Formula for calculation age

Good Afternoon,

We are capturing the data of birth on one of our forms, and I would like SS to calculate the age based on the DOB field. I am using this formula: YEAR(TODAY()) - YEAR(DOB1) to do that. My problem, is if the birthday is 6/1/2011, it is returning the age as 10 years old even though they won't be 10 until June 1.

What do I need to add to correct this?

All help is welcome.

Thank You,


Best Answer


  • Lloyd,

    Thank You. That solved my problem!

  • kinjal
    kinjal ✭✭

    These comments really helped me. what do I do if I want to change a format of the age in decimal like 13.4, 20.9. so year . month.