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.

How to use Microsoft 365’s dynamic array function SEQUENCE() to create a list of dates in Excel Your email has been sent Image: PixieMe/Shutterstock Must-read Windows coverage CrowdStrike Outage ...

Subtraction is the easiest way to count days between two dates in Excel. You can use the arithmetic operator – (minus sign) to subtract one date from another to find the number of days between them.

How to easily include dynamic dates in a Word doc using Excel Your email has been sent Microsoft Word has a date field, but it's not easy to use in an expression. If you need to update dates in a ...