DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM ...

An Excel table containing a date, the week number calculated through ISOWEEKNUM, and the total sales for each date. An Excel table that uses the SUMIF function with the ISOWEEKNUM function to ...

In the event that the cash flows are always collected on the same date every year, but an earlier date than the period's end, simply multiply the NPV by (1 + rate).

The IF function is one of the most flexible functions in Microsoft Excel and has a range of uses that can be helpful in comparing data entries and isolating specific data points. The IF function can ...

The year-end date input cell is named date_ye, the current-year cell is named date_cy, and the prior-year cell is named date_py. They were named by selecting each cell and typing the desired name into ...

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Where <cell with start date> and <cell with end date> specify the first and last date of the period between which you need the count of leap years. The dates are to be in MM/DD/YYYY format.

Excel’s YEARFRAC() function calculates the fraction of the year represented by the number of whole days between two dates using the form YEARFRAC(start_date, end_date, [basis]) ...