Excel: COUNTIF Less Than Date


You can use the following formula to count the number of cells in Excel that are less than a particular date:

=COUNTIF(A2:A11, "<"&D2)

This particular formula counts the number of cells in column A where the date is less than the date in cell D2.

The following example shows how to use this formula in practice.

Example: COUNTIF Less Than Date in Excel

Suppose we have the following dataset in Excel that shows the number of sales made by a company on various days:

Suppose we would like to count how many days are before 4/1/2022.

We can specify this date value in cell D2 and then type the following formula in cell E2:

=COUNTIF(A2:A11, "<"&D2)

The following screenshot shows how to use this formula in practice:

Excel COUNTIF less than date

We can see that there are a total of 6 days in column A that occur before 4/1/2022.

Note that if we change the date in cell D2, the value in cell E2 will automatically updated.

For example, suppose we change the date to 3/1/2022:

We can see that there are a total of 4 days in column A that occur before 3/1/2022.

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

COUNTIF vs. COUNTIFS in Excel: What’s the Difference?
How to Use COUNTIF with OR in Excel
How to Use COUNTIF From Another Sheet in Excel

Leave a Reply

Your email address will not be published. Required fields are marked *