Age Formula Excel 2013 in Year Month and Day

Each version of a software sometimes have different rules in certain respects. For example in the software application Microsoft Excel spreadsheets between the versions of Microsoft Excel 2010 to the 2013 version or the latest version 2016 may have differences in terms of a formula or function used. 

Here is of the formula or function in Microsoft Office Excel 2013 to calculate or determine a person's age automatically. By calculating and automatically determine a person's age, it will facilitate the work annually in terms of knowing and checking the age of an employees, or even our own age. 

Formula to calculate a person's age or the age of the Microsoft Excel following may be said to be complete because the age has appeared to age or the age in years, months and days. The formula or function to calculate and determine the age or the age of a person in Excel has been tested on Microsoft Excel 2013 with satisfactory results. 

Formula to calculate and determine the age can also be applied to determine and calculate the service life of a person in years, months and days. Let us practice directly about the function or formula to calculate and determine the age of person automatically in Microsoft Excel 2013 

The steps are as follows: 
  • Open your Microsoft Excel 2013 software 
  • Create a table with a data-name, date of birth, global age, the age in years, month and day of birth date with the date data format of Date type 
See examples in the below picture

http://reviewsdaily.blogspot.com/
  • Fill in each column's name and date of birth and others column 
  • In the global age, enter the function or the following formula: =""&DATEDIF(C3,TODAY(),"Y")&" Years "&DATEDIF(C3,TODAY(),"YM")&" Months "&DATEDIF(C3,TODAY(),"MD")&" days" 
  • In the column Age in Years, enter the formula: =""&DATEDIF(C3,TODAY(),"Y")&" Years " 
  • In the column age in months, enter the formula: =DATEDIF(C3,TODAY(),"YM")&" Months " 
  • In the Age column in the day, enter the formula: =DATEDIF(C3,TODAY(),"MD")&" days" 
Description C3 is the birth date column. 


That is a little tip how to calculate and determine the age of a person using formula or function in Microsoft Excel 2013 easily and quickly. These age formula excel or function can also be used to determine and calculate the service life of a person by referring to the date of entry or the date of start of work.

Post a Comment for "Age Formula Excel 2013 in Year Month and Day"