Hi.
I'm using DATEDIF to calculate a person's age ( DATEDIF(A1,NOW(),"y"). My question is how to calculate a person's age next b'day? The condition is, if the month for the person's b'day have not passed today's month, then the age is current age. If the month have passed today's month, then add 1 to the person's age.
Example:-
Cell A1 : 18-Aug-1967
DATEDIF(A1,NOW(),"y")
Result : 34 years
Age next b'day should be 34 years as the month (Aug) have not yet reached this year. If the month as exceed today's month, then add 1 to age ( i.e 35 years ).
Thanks
I'm using DATEDIF to calculate a person's age ( DATEDIF(A1,NOW(),"y"). My question is how to calculate a person's age next b'day? The condition is, if the month for the person's b'day have not passed today's month, then the age is current age. If the month have passed today's month, then add 1 to the person's age.
Example:-
Cell A1 : 18-Aug-1967
DATEDIF(A1,NOW(),"y")
Result : 34 years
Age next b'day should be 34 years as the month (Aug) have not yet reached this year. If the month as exceed today's month, then add 1 to age ( i.e 35 years ).
Thanks