If you are looking for ways **to use**** the COUNTIF function**** with multiple criteria date range in Excel**, then this article will be helpful for you. Sometimes you may want to count the dates based on multiple criteria rather than a single criterion. So, let’s get into the main article to know the details by going through the following **6 **examples.

## How to Use COUNTIF Function with Multiple Criteria Date Range in Excel: 6 Examples

Here, in the following dataset, we have some sales records with their corresponding selling dates. By using the following **6 **examples we will count dates depending on different criteria.

We have used ** Microsoft Excel 365 **version for creating this article. However, you can use any other version at your convenience.

__Example-1__: Counting Number of Different Dates Using COUNTIF Function with Multiple Criteria Date Range

Here, we will be counting two dates ** 1/9/2021 **and

**(**

*2/25/2021***mm/dd/yyyy**format) among the dates of the

**Date**range. These two criteria will be applied with the help of

**the COUNTIF function**.

- Type the following formula in cell
**E8**.

`=COUNTIF(C5:C15,"1/9/2021")+COUNTIF(C5:C15,"2/25/2021")`

Here, **C5:C15 **is the **date range**, and **“1/9/2021”**, and **“2/25/2021” **are the multiple criteria.

__Formula Breakdown__

**COUNTIF(C5:C15,”1/9/2021″) â†’**returns the number of times the date**1/9/2021**is presented in the range.**Output â†’ 2**

**COUNTIF(C5:C15,”2/25/2021″) â†’**returns the number of times the date**2/25/2021**is presented in the range.**Output â†’ 2**

**COUNTIF(C5:C15,”1/9/2021″)+COUNTIF(C5:C15,”2/25/2021″) â†’**becomes**2+2 â†’ 4**

- After pressing
**ENTER**, you will get**4**as the total number of presence of the specified dates.

__Example-2__: Applying SUMPRODUCT & COUNTIF Functions for Multiple Criteria in a Date Range

A similar task in **Example-1 **can be done using the combination of **the ****SUMPRODUCT** and **COUNTIF functions**.

- Apply the following formula in cell
**E8**.

`=SUMPRODUCT(COUNTIF(C5:C15,{"1/9/2021","2/25/2021"}))`

Here, **C5:C15 **is the **date range**, and **“1/9/2021”**, and **“2/25/2021” **are the multiple criteria.

__Formula Breakdown__

**COUNTIF(C5:C15,{“1/9/2021″,”2/25/2021”}) â†’**returns an array containing the number of presence of the dates**“1/9/2021”**, and**“2/25/2021”**in the date range.**Output â†’ {2,2}**

**SUMPRODUCT({2,2}) â†’**adds the values up inside the array**Output â†’ 4**

- After pressingÂ
**ENTER**, you will get**4**as the total number of presence of the specified dates.

**Note**: You have to press

**CTRL+SHIFT+ENTER**instead of pressing

**ENTER**while using any other versions except for

*Microsoft Excel 365*.

**Read More: SUMPRODUCT and COUNTIF Functions with Multiple Criteria**

__Example-3__: Counting Numbers Between Two Dates

In this section, we will try to count the number of dates from the month of ** March **presented in the

**Date**column.

- Type the following formula in cell
**E8**.

`=COUNTIF(C5:C15,">3/1/2021")-COUNTIF(C5:C15,">3/30/2021")`

Here, **C5:C15 **is the **date range**, **“>3/1/2021”**, and **“>3/30/2021” **are the multiple criteria.

__Formula Breakdown__

**COUNTIF(C5:C15,”>3/1/2021″) â†’**counts the number of dates greater than the start date of**March****Output â†’ 4**

**COUNTIF(C5:C15,”>3/30/2021″) â†’**counts the number of dates greater than the ending date of**March****Output â†’ 2**

**COUNTIF(C5:C15,”>3/1/2021″)-COUNTIF(C5:C15,”>3/30/2021″) â†’**becomes**4-2 â†’ 2**

- Press
**ENTER**.

In this way, you will have the total number of dates from **March **month and here the result is **2**.

**Read More: ****How to Use COUNTIF Between Two Dates and Matching Criteria in Excel**

__Example-4__: Using DATE Function with COUNTIF Function in Excel

Here, we will try to count the number of dates from the month of ** March **presented in the

**Date**column using

**the**

**COUNTIF**and

**DATE**

**functions**.

- Type the following formula in cell
**E8**.

`=COUNTIF(C5:C15,">"&DATE(2021,3,1))-COUNTIF(C5:C15,">"&DATE(2021,3,30))`

Here, **C5:C15 **is the **date range**.

__Formula Breakdown__

**DATE(2021,3,1) â†’**returns date with the year**2021**, month**3**, and**1st**day of this month.**Output â†’ 3/1/2021**

**COUNTIF(C5:C15,”>”&DATE(2021,3,1)) â†’**becomes**COUNTIF(C5:C15,”>”&3/1/2021) â†’ The & operator**joins the greater than sign with the date.**COUNTIF(C5:C15,”>3/1/2021″) â†’**counts the number of dates greater than the start date of**March****Output â†’ 4**

**DATE(2021,3,30) â†’**returns date with the year**2021**, month**3**, and**30th**day of this month.**Output â†’ 3/30/2021**

**COUNTIF(C5:C15,”>”&DATE(2021,3,30)) â†’**becomes**COUNTIF(C5:C15,”>”&3/30/2021) â†’ The & operator**joins the greater than sign with the date.**COUNTIF(C5:C15,”>3/30/2021″) â†’**counts the number of dates greater than the start date of**March****Output â†’ 2**

**COUNTIF(C5:C15,”>”&DATE(2021,3,1))-COUNTIF(C5:C15,”>”&DATE(2021,3,30)) â†’**becomes**4-2 â†’ 2**

- Press
**ENTER**.

Later, you will have the total number of dates from **March **month and here the result is **2**.

**Similar Readings**

**How to Use COUNTIF with Multiple Criteria in the Same Column in Excel****COUNTIF with Multiple Criteria in Different Columns in Excel**

__Example-5__: Applying EOMONTH and COUNTIF Functions with Multiple Criteria in a Date Range

Here, we will try to count the number of dates from the month of ** March **presented in the

**Date**column using

**the**

**COUNTIF**and

**EOMONTH**

**functions**.

- Type the following formula in cell
**E8**.

`=COUNTIF(C5:C15,">"&E6)-COUNTIF(C5:C15,">"&EOMONTH(E6,0))`

Here, **C5:C15 **is the **date range**, and **E6 **is the starting date of ** March**.

__Formula Breakdown__

**COUNTIF(C5:C15,”>”&E6) â†’**becomes**COUNTIF(C5:C15,”>”&3/1/2021) â†’ The & operator**joins the greater than sign with the date.**COUNTIF(C5:C15,”>3/1/2021″) â†’**counts the number of dates greater than the start date of**March****Output â†’ 4**

**EOMONTH(E6,0)**returns the end date of*March***Output â†’ 3/31/2021**

**COUNTIF(C5:C15,”>”&EOMONTH(E6,0)) â†’**becomes**COUNTIF(C5:C15,”>”&3/31/2021) â†’ The & operator**joins the greater than sign with the date.**COUNTIF(C5:C15,”>3/31/2021″) â†’**counts the number of dates greater than the start date of**March****Output â†’ 2**

**COUNTIF(C5:C15,”>”&DATE(2021,3,1))-COUNTIF(C5:C15,”>”&DATE(2021,3,31)) â†’**becomes**4-2 â†’ 2**

- After pressing
**ENTER**, we are getting the total number of dates from**March**in the**Date**column.

__Example-6__: Implementing COUNT, IF, MONTH, and YEAR Functions

Here, we will count the number of dates from ** January **month and the dates from this month when the sales values were greater than

**5000 USD**. For this purpose, we are going to use the combination of the

**COUNT**,

**IF**,

**MONTH**, and

**YEAR**

**functions**.

- Apply the following formula in cell
**E8**.

`=COUNT(IF(MONTH(C5:C15)=1,IF(YEAR(C5:C15)=2021,IF(D5:D15>5000,D5:D15))))`

Here, **C5:C15 **is the **date range**.

__Formula Breakdown__

**MONTH(C5:C15)=1 â†’ MONTH**returns the month values of the dates**{1;1;1;2;2;3;3;1;4;4;2} = 1 â†’**returns**TRUE**for**1**in the array**Output â†’ {TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE}**

**YEAR(C5:C15)=2021 â†’ YEAR**returns the year values of the dates**{2021;2021;2021;2021;2021;2021;2021;2021;2021;2021;2021} = 2021 â†’**returns**TRUE**for**2021**in the array**Output â†’ {TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE}**

**D5:D15>5000 â†’**returns**TRUE**when the sales values are greater than**5000****Output â†’ {FALSE;TRUE;TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}**

**IF(D5:D15>5000,D5:D15) â†’**becomes**IF({FALSE;TRUE;TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE},D5:D15)****Output â†’ {FALSE;5935;6835;7871;9496;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}**

**IF(YEAR(C5:C15)=2021,IF(D5:D15>5000,D5:D15)) â†’**becomes**IF({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE},{FALSE;5935;6835;7871;9496;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE})****Output â†’ {FALSE;5935;6835;7871;9496;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}**

**IF(MONTH(C5:C15)=1,IF(YEAR(C5:C15)=2021,IF(D5:D15>5000,D5:D15))) â†’**becomes**IF({TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;TRUE;FALSE;FALSE;FALSE},{FALSE;5935;6835;7871;9496;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE})****Output â†’ {FALSE;5935;6835;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}**

**COUNT(IF(MONTH(C5:C15)=1,IF(YEAR(C5:C15)=2021,IF(D5:D15>5000,D5:D15)))) â†’**becomes**COUNT({FALSE;5935;6835;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}) â†’**counts the number values in the range**Output â†’ 2**

- Press
**ENTER**.

In this way, you will get the total number **2 **for the sales values greater than **5000 USD **during **January **month.

**Note**: You have to press

**CTRL+SHIFT+ENTER**instead of pressing

**ENTER**while using any other versions except for

*Microsoft Excel 365*.

## Applying COUNTIFS Function for Multiple Criteria in a Date Range in Excel

Here, we are going to use **the COUNTIFS function** for counting values based on multiple criteria of the **Date** range and the **Sales** range. So, we will count the number of dates from ** January **month and the dates from this month when the sales values were greater than

**5000 USD**.

- Type the following formula in cell
**E8**.

`=COUNTIFS(C5:C15,">1/1/2021",C5:C15,"<1/31/2021",D5:D15,">"&5000)`

Here, **C5:C15**, and **D5:D15 **are the **criteria** ranges, **“>1/1/2021”**, **“<1/31/2021”**, and **“>”&5000 **are the criteria.

- Press
**ENTER**.

Eventually, you will get the total number **2 **for the sales values greater than **5000 USD **during **January **month.

## Practice Section

For doing practice, we have added a **Practice** portion on each sheet on the right portion.

**Download Workbook**

## Conclusion

In this article, we tried to show some examples related **to using the COUNTIF function with multiple criteria date range in Excel**. Hope you will find it useful. If you have any suggestions or questions, feel free to share them in the comment section.

## Related Articles

**COUNTIF Between Two Values with Multiple Criteria in Excel****How to Use COUNTIF for Cells Not Equal to Text or Blank in Excel****How to Use COUNTIF Function Across Multiple Sheets in Excel****How to Apply SUM and COUNTIF for Multiple Criteria in Excel****How to Apply COUNTIF with Multiple OR Criteria in Excel**

**<< Go Back to COUNTIF Multiple Criteria | Excel COUNTIF Function | Excel Functions | Learn Excel**