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.

Click the drop-down arrow in this area and choose either of the two "Date" options. The long number in the cell with transform a date, which will be the midpoint between your two given dates.

You already knew that Excel can do straight date math, but it can also take into account holidays to find the number of working days between two dates. Tech blogger Chandoo points out the ...

Excel makes it easy to find how many days there are between two dates. With a little more effort, you can find the number of days in which people will be actually working.