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.

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.

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

Steps:

• Firstly, select Cell C13.
• Then, insert the following formula.

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.

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

Steps:

• In the beginning, select Cell C15.
• Then, insert the following formula.

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.

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

• How to Compare If Date Is Before Another Date in Excel
• Excel Formula If One Date is Greater Than Another Date
• Conditional Formatting for Dates Older Than Certain Date in Excel
• Excel Formula If Date Is Less Than Today (4 Examples)
• How to Find If Date Is Within 3 Months in Excel (5 Easy Ways)
• If Cell Contains Date Then Return Value in Excel (5 Examples)
• Conditional Formatting Based on Date Older Than 1 Year in Excel