Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Use COUNTIF for Date Greater Than 30 Days in Excel

Looking for ways to know how to count date greater than 30 days using COUNTIF Function in Excel? Sometimes, we want to count dates that are greater than 30 days. We can do it using COUNTIF Function. Here, you will find 2 ways to count date greater than 30 days using COUNTIF Function in Excel.


Download Practice Workbook


2 Ways to Use COUNTIF for Date Greater Than 30 Days in Excel

Here, we have a dataset containing some Name and Order Received Date. Now, we will use this dataset to show you how to count dates greater than 30 days using the COUNTIF Function in Excel.

Ways to Countif Date Greater than 30 Days in Excel


1. Using COUNTIF and TODAY Functions to Count Date Greater Than 30 Days

In the first method, we will show you how to use the COUNTIF and TODAY Functions to count date greater than 30 days. The COUNTIF function is used to count the number of cells in a particular range which returns TRUE for the given condition and the TODAY function returns the current date.

Using COUNTIF and TODAY Functions to Count Date Greater than 30 Days

Follow the steps given below to do it on your own.

Steps:

  • Firstly, select Cell C13.
  • Then, insert the following formula.
=COUNTIF(C5:C11,">"&TODAY()-30)

Here, in the COUNTIF function, we inserted Cell range C5:C11 as range and as criteria we concatenate the greater than operative with the TODAY function and then subtracted the value by 30 to get the number of dates greater than 30 days.

  • After that, press ENTER.
  • Finally, you will get the number of date greater than 30 days from the current date using the COUNTIF and TODAY functions.

Read More: Excel Formula If Date Is Greater Than 365 Days (4 Ideal Examples)


2. Count Date Greater Than 30 Days Using Specific Date

We can also count date greater than 30 days using a specific date and the COUNTIF function in Excel.

Count Date Greater than 30 Days Using Specific Date

Go through the steps given below to do it on your own.

Steps:

  • In the beginning, select Cell C15.
  • Then, insert the following formula.
=COUNTIF(C5:C11,">"&C13)

Here, in the COUNTIF function, we inserted Cell range C5:C11 as range and as criteria we concatenate the greater than operator with Cell C13 using Ampersand Operator (&). This will compare the given date with the date range.

  • Then, press ENTER.
  • Finally, you will get the number of date greater than 30 days using a specific date in Excel.

Read More: Excel Formula If Date Is Greater Than 2 Years (3 Examples)


Practice Section

In this section, we are giving you the dataset to practice on your own and learn to use these methods.

Practice Section


Conclusion

So, in this article, you will find 2 ways to count date greater than 30 days using COUNTIF Function in Excel. Use any of these ways to accomplish the result in this regard. Hope you find this article helpful and informative. Feel free to comment if something seems difficult to understand. Let us know any other approaches which we might have missed here. And, visit ExcelDemy for many more articles like this. Thank you!


Related Articles

Arin Islam

Arin Islam

Hello, I'm Arin. I graduated from Khulna University of Engineering and Technology (KUET) from the Department of Civil Engineering. I am passionate about learning new things and increasing my data analysis knowledge as well as critical thinking. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to it.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo