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

Question

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

Report

doublewitt

Posts: 14
Registration date: Sunday April 27, 2014
Status: Member
Last seen: September 29, 2014

- May 18, 2014 at 04:25 PM
doublewitt

Posts: 14
Registration date: Sunday April 27, 2014
Status: Member
Last seen: September 29, 2014

- May 19, 2014 at 10:48 AM

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...

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
How to count conditionally formatted cells in excel - Forum - Excel
What values are possible for cells that contain numbers, dates and text? ✓ - Forum - Excel

2 replies

Ask a question

venkat1926 · Answer 1 · 2014-05-19T00:15:13-0400

Answer 1 / 2

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

796
May 19, 2014 at 12:15 AM

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

doublewitt · Answer 2 · 2014-05-19T10:48:27-0400

Answer 2 / 2

doublewitt

Posts: 14
Registration date: Sunday April 27, 2014
Status: Member
Last seen: September 29, 2014

May 19, 2014 at 10:48 AM

Thanks, that works fine...!

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

2 replies

Your reply

Subscribe To Our Newsletter!