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 ...

In Microsoft Excel, you don’t need an expression to calculate someone’s age – use Power Query to simplify the process.

Image: Ahmad/Adobe Stock. An expression to return a simple running total in Excel is easy — a few references and you’re done. A conditional running total takes more work. The expressions aren ...