How to count number of cells dated this week? or next week?
Solved/Closed
doublewitt
Posts
14
Registration date
Sunday 27 April 2014
Status
Member
Last seen
29 September 2014
-
18 May 2014 à 16:25
doublewitt Posts 14 Registration date Sunday 27 April 2014 Status Member Last seen 29 September 2014 - 19 May 2014 à 10:48
doublewitt Posts 14 Registration date Sunday 27 April 2014 Status Member Last seen 29 September 2014 - 19 May 2014 à 10:48
Related:
- How to count number of cells dated this week? or next week?
- Count number of occurrences in excel - Guide
- Windows calendar show week number - Guide
- How to hide subscriber count - Guide
- How to count names in excel - Guide
- Show week number in google calendar - Guide
2 responses
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
19 May 2014 à 00:15
19 May 2014 à 00:15
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
doublewitt
Posts
14
Registration date
Sunday 27 April 2014
Status
Member
Last seen
29 September 2014
19 May 2014 à 10:48
19 May 2014 à 10:48
Thanks, that works fine...!
