How to Calculate Age in Excel from a Date of Birth
Calculate age in Excel from a birth date with DATEDIF: years only, years and months, age on a specific date, and why YEARFRAC rounds wrong.
Calculate age in Excel from a birth date with DATEDIF: years only, years and months, age on a specific date, and why YEARFRAC rounds wrong.
GETPIVOTDATA in Excel: what the formula Excel writes for you means, how to make it use a cell instead of fixed text, and how to turn it off if you just want =B5.
Count unique values in an Excel pivot table with Distinct Count — the one tick box when you create the pivot — plus the helper-column way for older Excel.
Get an Excel table into Word three ways: paste as a Word table, paste as a picture, or paste a link that updates when the spreadsheet changes.
Convert Excel to JSON with a formula that builds each row, with Power Query for clean output, or with a free converter — and the shape developers expect.
Hide rows in Excel with Ctrl+9, hide every row that matches a filter, unhide one or all, and use Group to collapse sections instead.
Protect a sheet in Excel so cells cannot be changed, allow specific cells to stay editable, choose what users may still do, and unprotect.
Make a scatter plot in Excel, add a trendline and its equation, label the points with names, and read what the pattern means.
Print gridlines in Excel with one tick box, print them for part of a sheet, use borders when gridlines won't print, and fix the greyed-out option.
One short Excel lesson in your inbox every morning. Free, no spam, unsubscribe any time.
Also join us on Facebook