ExcelBanter - Can anyone calculate age next birthday from date field?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can anyone calculate age next birthday from date field? (https://www.excelbanter.com/excel-worksheet-functions/74009-can-anyone-calculate-age-next-birthday-date-field.html)

Sheila

Can anyone calculate age next birthday from date field?

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

Gary''s Student

Can anyone calculate age next birthday from date field?

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?

All times are GMT +1. The time now is 02:09 PM.