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

Get FREE Advanced Excel Exercises with Solutions!

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


How to Use COUNTIF for Dates Greater Than 30 Days in Excel: 2 Simple Ways

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 dates 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 dates greater than 30 days from the current date using the COUNTIF and TODAY functions.


2. Count Date Greater Than 30 Days Using Specific Date

We can also count dates 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 dates greater than 30 days using a specific date in Excel.


Practice Section

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

Practice Section


Download Practice Workbook


Conclusion

So, in this article, you will find 2 ways to count dates greater than 30 days using the 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. Thank you!


<< Go Back to Dates | Compare | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Arin Islam
Arin Islam

Anowara Islam Arin, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Arin exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Besides, she is also interested in Advanced Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo