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.

Kumar Malyala asked if there’s a way in Excel to count the number of business days between two dates. However, if you don’t want Saturdays and Sundays in your total, you’ll have to work a bit harder.

Q. Is there a quick way in Excel to calculate the number of business days in a particular period? For example, a CPA preparing payroll may need to determine how many business days he or she has to ...