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.

The DAYS360 function returns the number of days between two dates centered on a 360-day year (twelve 30-day months), used in some accounting calculations.

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.

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 ...