Can anyone calculate age next birthday from date field?

S

Sheila

I am having great difficulty in creating a formula which will show the age
next birthday. Has anyone achieved this?
 
G

Gary''s Student

Your age on your next birthday is always one more than you age today (even if
today is your birthdate):

put your birthday in A1 and then:


=DATEDIF(A1,TODAY(),"y")+1
is what you want.
 
Top