OzGrid

Count Between Date Ranges

< Back to Search results

 Category: [Excel]  Demo Available 

Count Between Date Ranges

 

Got any Excel/VBA Questions? Free Excel Help

Count Between Date Ranges.

To count dates that fall between a date range we can use SUMPRODUCT with a twist. Suppose you have a list of valid dates in A1:A20. The formula we can use to count dates that fall between 2 dates is:

=SUMPRODUCT(($A$1:$A$20>D1)*($A$1:$A$20<E1))

Where D1 houses your start date and E1 you end date.

Or, we can hard code the dates into our SUMPRODUCT Function by using the DATE Function.

=SUMPRODUCT(($A$1:$A$20>DATE(2010,7,29))*($A$1:$A$20<DATE(2010,8,1)))

Syntax for the date function is: DATE(Year, Month, Day)

 

See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets

 

See also:

Convert Dates To Excel Formatted Dates
Convert Excel Formula/Functions to Values
Converting Numbers Seen Text By Excel to Real Numbers
Convert Excel Dates/Time to True Dates & Times
Copy, Cut & Paste Special in Excel

 

Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.

 

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.


Gallery



stars (0 Reviews)