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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Date of next birthday 4
Date Functions 5
calculate date of birth with an end date and age 1
How do I put in a formula in Exel to calculate a persons age? 11
create calculated field for age in pivot tables 4
Conditional formula's in excel-calculating with dates / age andaffiliation date calculus 3
Calculate horses age as at 1 August 6
Working on birthday "book" for my wife and having layout/editing trouble 0

Top