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.

If you want to calculate how much time is left until a certain expiry date, you can use the DATEDIF function. This function returns the difference between two dates in terms of days, months, or years.

Excel's Date & Time functions help you calculate a day's serial number, move to a 360-day accounting calendar, and more. We cover Date, Days, Days360, Time, and Weekday ...

An Excel sheet containing a SEQUENCE formula containing the DATE function. A list of tasks in column B in Excel, with column A left blank for automatic numbering to be added.