Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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

Answer 1 / 2
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
 800
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
Answer 2 / 2
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
Thanks, that works fine...!
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!