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.

Last week I explained how Excel uses its own, unique system of serial numbers to calculate dates and times. That piece covered nine Date & Time functions: NETWORKDAYS(), DATEVALUE(), NOW(), DAY(), ...

The DAYS function in Microsoft Excel returns the number of days between two dates. The formula for the DAYS (end_date, start_date). The DAYS360 function returns the number of days between two dates ...