DPChristman
Board Regular
- Joined
- Sep 4, 2012
- Messages
- 171
- Office Version
- 365
- Platform
- Windows
I have a strange error that I am running into with trying to determine the age of an employee.
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?
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?