How to count number of cells dated this week? or next week? [Solved/Closed]

Report
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
I've got lots of cells with dates. I want to know how many are THIS WEEK and NEXT WEEK. I'm not sure how to do it...

Help would be appreciated...

2 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014

Thanks, that works fine...!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!