I am a real novice at formulas and I have been unable to work out what I have done wrong. Can somebody please tell me.
I am trying to return the age of a person based on the difference between the DOB and the date in the future. What I have here works sometimes but sometimes gives the incorrect age. The problem occurs if the dob is later in the year than todays date.
Hopefully the link will show that the first age (for Jacob) is correct but the second line for (Peter) is one year out.