I try to make a simple sheet to determine the age of a person. However when the year of birth is '73, '77, or '81 I do not get the right age, but 1 year less.(only when the day and month are the same)
fi. born 24-02-1973. Today ia 24-02-2002.
Formula calculates 28 must be 29.
Because I have to use the age for another formula I use the following formula
Right(YEAR(TODAY()-(G2-1));2)+0 WHERE
G2 is the date of birth.
Can somebody help me??
Harry
fi. born 24-02-1973. Today ia 24-02-2002.
Formula calculates 28 must be 29.
Because I have to use the age for another formula I use the following formula
Right(YEAR(TODAY()-(G2-1));2)+0 WHERE
G2 is the date of birth.
Can somebody help me??
Harry