How to count number of cells dated this week? or next week?
Solved/Closed
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
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 19, 2014 at 10:48 AM
Related:
- How to count number of cells dated this week? or next week?
- Windows calendar show week number - Guide
- Free epic games this week - Guide
- Mac calendar show week number - Guide
- "Yay! it's whatsapp's birthday! if you send this message to 12 people, you get 120 new emojis. how cute! (it works) 🌈this is an official whatsapp message... whatsapp celebrates its 11th birthday! you will get a colorful keyboard, if you send this message to 25 people, attention: not one more, not one less! ⚠ hurry the deadline is limited to one week ⚠ it is done ? look at your keyboard.😉 - Internet & Social Networks Forum
- Pls Attention - MacOS Forum
2 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 19, 2014 at 12:15 AM
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
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 April 27, 2014
Status
Member
Last seen
September 29, 2014
May 19, 2014 at 10:48 AM
May 19, 2014 at 10:48 AM
Thanks, that works fine...!
