Can anyone calculate age next birthday from date field? in Excel Worksheet Functions  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Sheila 2/26/2006 8:54 AM PST
  Question
  I am having great difficulty in creating a formula which will show the age
next birthday. Has anyone achieved this?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Gary''s Student  2/26/2006 9:11 AM PST
  Answer
  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?
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies