Excel quietly supports a function it does not list: DATEDIF.

🤯 Verified Fact · Excel

Wacky WorldExcel & Office

DATEDIF calculates the difference between two dates in days, months or years. It came from Lotus 1-2-3 compatibility, does not appear in Excel’s function autocomplete, yet still works in every version.

Source: support.microsoft.com

Another wacky fact → All facts

Explore more Excel & Office facts

ExcelExcel can nest up to 64 levels of functions.ExcelVisiCalc, the first PC spreadsheet, sold Apple II computers.ExcelExcel stores every date as a number.
🔬 Verified Citation:support.microsoft.com ↗