Piriyanka

  How to Calculate Current Age in Full Years If you want to calculate someone’s current age from their date of birth, the best choice is to use the  YEARFRAC  function. This returns the total number of completed years plus the fraction of the current year. Since people usually give their age in completed years, we can truncate the result to remove the decimal part and just leave the number of years. To calculate age in years using YEARFRAC: Open Excel. Click in the cell where you want the age to appear. Type  =TRUNC(YEARFRAC( Select the cell containing the date of birth. Type  ,TODAY()))  and press  Enter . The person’s age in years is calculated. If you have other ages you need to calculate, click the cell containing your formula, then click and hold the small square in the bottom right-hand corner of the cell. Drag down to apply the formula to other cells. Release the mouse—your other ages will calculate. How to Calculate Current Age in Years and Months To calculate age in years and

Formulas/Functions SUM function – Sum multiple values in Excel MAX – find the maximum value in a range MIN – find the minimum value in a range COUNT – Count numeric values in a range COUNTA – Count numeric and textual values AVERAGE – Calculate average of a range IF function – check if a condition is met COUNTIF – Count cells in range which meet a certain criteria SUMIF – Sum range based on criteria AVERAGEIF – Calculate the average of a range based on criteria SUMIFS – Sum cells using multiple criteria COUNTIFS – Count cells using multiple criteria   MAXIFS – Find maximum value in a range based on criteria MINIFS – Find minimum value in a range based on criteria AND/OR – Check if multiple criteria are met (Works great when combined with an IF function!) ISBLANK – Check if a cell is blank or not VLOOKUP – lookup value and return corresponding value from a table HLOOKUP – lookup value and return corresponding value from a table LEFT, MID, RIGHT – Basic Text Functions FIND – Find the pos