MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Kevin on January 07, 2002 2:24 AM

I want to count the number of times a date appears in one col on my spread sheet ive used COUNTIF to look at a specific date but would like to be able to lookup a range rather than individually for example dates >= 03/01/2002 <=02/02/2002 is this achievable using formulas?

Any help please

Posted by Aladin Akyurek on January 07, 2002 3:03 AM

Kevin --

Enter the criterion dates in cells of their own, say in E1 and E2, where E1 < E2 (that's, E1 comes before E2 in time).

Lets say that A2:A100 houses the dates to which you want to apply a formula that counts dates according the criteria/conditions in E1 and E2:

In say B2 enter: =COUNTIF(A2:A100,">="&E1)-COUNTIF(A2:A100,">"&E2)

will give you the desired count.

Note. A2:A100, E1, and E2 must be date formatted in the same way.



Posted by Kevin on January 07, 2002 4:09 AM

Many Many thanks

You have saved me so much time and it works a treat

Thanks again