When counting unique values in Microsoft Excel, use UNIQUE() as a helper function and avoid more complicated expressions.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

Note that the content that follows is based on Microsoft Excel 365 for PCs. Other versions of Excel may work differently. Let’s look at some examples of how to use COUNTIF and COUNTIFS. First, let’s ...