Countif in Excel

Column C is a long list of dates.

I would like cell H3 to count all the dates that are inbetween the date listed in cell F3 and G3 (F3 and G3 are in order with F3 being the first date and G3 being the later date).

Any idea how to do this?


Who is Participating?
OCDanConnect With a Mentor Commented:
There are few ways but I generally use the sumproduct method:

Assuming all the dates are in cells c1-c100, and startdate in f3 and enddate in g3

Kyle AbrahamsSenior .Net DeveloperCommented:
Update your range as necessary:
barry houdiniCommented:
The most efficient way in Excel 2007 is to use COUNTIFS


regards, barry
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.