Age Calculation

Age Calculation
You can calculate a person’s age based on their birthday and today’s date.. 





Microsoft Excel Function

You can calculate a person’s age based on their birthday and today’s date.                                                                          

The calculation uses the DATEDIF() function.                                                                      

The DATEDIF() is not documented in Excel 5, 7 or 97, but it is in 2000.                                                                      
(Makes you wonder what else Microsoft forgot to tell us!)                                                                         
                                                                                               
                Birth date :          29-Apr-95                                                           
                                                                                               
                Years lived :        22           =DATEDIF(C8,TODAY(),"y")                                       
                and the months :             1              =DATEDIF(C8,TODAY(),"ym")                                   
                and the days :    24           =DATEDIF(C8,TODAY(),"md")                                   
                                                                                               
You can put this all together in one calculation, which creates a text version.                                                                      
                Age is 22 Years, 1 Months and 24 Days                                                                   
                 ="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days"                                                                               
                                                                                               
                                                                                               
Another way to calculate age                                                                    
This method gives you an age which may potentially have decimal places representing the months.                                                                       
                If the age is 20.5, the .5 represents 6 months.                                                                    
                                                                                               
                Birth date :          1-Jan-90                                                              
                                                                                               

                Age is :  27.47     =(TODAY()-C23)/365.25                
Age Calculation Reviewed by Rupesh on 10:00 Rating: 5

No comments:

All Rights Reserved by Technology from Developers Eye © 2014 - 2015
Powered By Blogger, Designed by Aadics
Disclaimers:: The information provided within this blogsite is for general informational purposes only. While we try to keep the information up-to-date and correct, there are no representations or warranties, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the information, products, services, or related graphics contained in this blogsite for any purpose.The author does not assume and hereby disclaims any liability to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from accident, negligence, or any other cause.

Contact Form

Name

Email *

Message *

Powered by Blogger.