Forum Discussion
Age formula not calculating
Good day, I am a beginner Excel user and am trying to calculate age between 2 different dates where B2 contains the date of diagnosis of a disease and E2 contains the date of birth. The column with m...
Another formula you can use is
=(G2-E2)/365.25 (the .25 because that is the more precise number of days in a year, accounting for leap years)
That formula has been put into the attached copy of your spreadsheet.
Separate issue: the copy you posted contained information that should have been deleted before posting...names of patients. It's important that such private info NOT be posted. You can remove the sheet yourself, but if you don't get to it in time, I've alerted the board moderators to take it down. In the copy I'm attaching, the sheet with those names has been removed.
