How to Calculation Age and Birth Day in Excel

 How to Calculation Age and Birth Day in Excel

You can calculate  a person age based on their birthday and todays date.
The calculation uses the DATEDIF() function 

 =DATEDIF(C3,TODAY(),"y")

 =DATEDIF(C3,TODAY(),"ym")
 
=DATEDIF(C3,TODAY(),"md")

You can put this all together in one calculation, which creates a text version.

 ="Age is "&DATEDIF(C3,TODAY(),"y")&" Years, "&DATEDIF(C3,TODAY(),"ym")&" Months and "&DATEDIF(C3,TODAY(),"md")&" Days"












Comments

Post a Comment

Popular posts from this blog

How to Split Forename and Surname (LEFT, RIGHT, MIDDLE) formula in EXCEL

Image
 How to Split Forename and Surname (LEFT, RIGHT, MIDDLE) formula in EXCEL The following formula are useful when you have one cell containing text which needs to be split up. The formula use various text functions to accomplish the task. Each of the techniques uses the space between the names to identify where to split. Finding the Last name when a Middle name is present The formula above cannot handle any more than two names.If there is also a middle name, the last name formula will be incorrect.To solve the problem you have to use a much longer calculation.
Read more