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.

Excel's EDATE and NOW functions can be used to track when an account is overdue, and let the person managing the account know when to send a reminder notice. Functions such as this enable better cash ...

Excel spreadsheets permit you to stay organized while managing large amounts of data, which can be organized in a number of ways. One popular way to organize this data is by date. Excel has a default ...

As you create Excel spreadsheets for your small business, time and date functions frequently add both convenience and programming capability to your workbooks. There's good news with date functions.

The Excel Date & Time functions I’m covering here—EDATE, YEARFRAC, EOMONTH, and NETWORKDAYS.INTL—are four of the many used for counting days. For each function listed below, I’ll define it first, then ...