Related:
- How to count number of cells dated this week? or next week?
- Count no. of Cell with particular color in a row/Column - How-To - Excel
- Text String count within a Cell ✓ - Forum - Office Software
- Count number of cells matching to criteria ✓ - Forum - Excel
- Count conditionally formatted cells in excel 2007 - Forum - Excel
- VBA - Count the number of colored cells - How-To - Excel
2 replies
venkat1926
- Posts
- 1862
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- July 30, 2015
suppose data from A1 to A21 is
date
15-May
16-May
17-May
18-May
19-May
20-May
21-May
22-May
23-May
24-May
25-May
26-May
27-May
28-May
29-May
30-May
31-May
1-Jun
2-Jun
3-Jun
use this formula
=COUNTIFS(A2:A21,">=5/18/14",A2:A21,"<6/1/14")
change the dates if necessary
in my regional configuration dates are entered as m/d/yy
date
15-May
16-May
17-May
18-May
19-May
20-May
21-May
22-May
23-May
24-May
25-May
26-May
27-May
28-May
29-May
30-May
31-May
1-Jun
2-Jun
3-Jun
use this formula
=COUNTIFS(A2:A21,">=5/18/14",A2:A21,"<6/1/14")
change the dates if necessary
in my regional configuration dates are entered as m/d/yy
Subscribe To Our Newsletter!
