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