Baggeepants
New Member
- Joined
- Jan 9, 2018
- Messages
- 8
I am trying to get Excel to calculate the age of a person on a certain date but have found the formula I am using in column C =(YEAR(B1)-YEAR(A1)) works in some cells but most are returning the #VALUE error code. I have formatted the cells in column A & B as 'Date' & column C as 'Number' with zero decimal points. In rows 1, 3, 4 & 7 I expect the error code until I can correct the spreadsheet with the actual date but rows 2, 5 & 6 should show the approx. age of the person as rows 8 to 13 do. Is there another formula that can do this subtraction or does the formula I am using require tweaking?