#### DPChristman

##### Board Regular

- Joined
- Sep 4, 2012

- Messages
- 139

The formula I have in place is =SUM(NOW()-H5)/365, where H5 is the date of birth.

The formula works most of the time, but then I get these odd incorrect responses.

I have added multiple decimal points to try and get the age as accurate as possible, and still getting these errors.

Example using today's date (10/26/2020), and a birth date of 11/1/1990, the formula returns a value of 30.007.

This is clearly wrong. Does anyone know a fix or have a better formula for this?