To count the number of days between two dates in Excel, you can use either the COUNTIFS or SUMPRODUCT function. The COUNTIFS function counts the number of cells in a range that meet multiple criteria, while SUMPRODUCT multiplies arrays and returns their sum. Both functions require a date range with a lower and upper date … Continue reading Counting the Number of Days Between Two Dates in Excel