To calculate someone's age in Excel, enter the formula =DATEDIF(A2,TODAY()," y"), where cell A2 contains the date they were born and "Today" is today's date. Press Enter, and Excel will output the ...

Use Excel’s YEARFRAC() function to calculate age. This function is easy to use if you know about it. The biggest obstacle is knowing which argument to use: For the most part, the way you’re ...

An Excel sheet containing an AVERAGEIF formula to calculate the average salary of people aged over 40. An Excel table ...