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.
--
Gary's Student


"Sheila" wrote:

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