DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works.

Microsoft Excel provides a function that displays a person's age based on his date of birth. In your business, this function can help you keep track of your workers' ages in a spreadsheet; you'll need ...