How to count date cells for monday of this week
Solved/Closed
doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
-
Sep 25, 2014 at 07:53 AM
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - Sep 29, 2014 at 11:49 AM
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - Sep 29, 2014 at 11:49 AM
Related:
- "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.
- How to type ' on keyboard - Guide
- Voice message downloader - Guide
- How to know if someone is spying on your whatsapp - Guide
- How to get whatsapp verification code online - Guide
- Send popup message to another computer on network windows 10 - Guide
3 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 25, 2014 at 11:15 AM
Sep 25, 2014 at 11:15 AM
Hi Doublewitt,
I entered date's in the range A1:A30 starting with 15-9-2014 and ending with 14-10-2014.
The following formula gives me 8 as a result (Monday of current week):
=COUNTIF(A1:A30,"<=22-9-2014")
This formula gives me 15 as a result (Monday of next week):
=COUNTIF(A1:A30,"<=29-9-2014")
Best regards,
Trowa
I entered date's in the range A1:A30 starting with 15-9-2014 and ending with 14-10-2014.
The following formula gives me 8 as a result (Monday of current week):
=COUNTIF(A1:A30,"<=22-9-2014")
This formula gives me 15 as a result (Monday of next week):
=COUNTIF(A1:A30,"<=29-9-2014")
Best regards,
Trowa
doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
Sep 25, 2014 at 12:01 PM
Sep 25, 2014 at 12:01 PM
thanks for the effort but that's not quite what I need - perhaps I need to explain better. Can we create a formula based on the year's current week number in another cell? In other words, count total number of cells containing monday's date within current week 39.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Sep 29, 2014 at 11:35 AM
Sep 29, 2014 at 11:35 AM
Hi Doublewitt,
So you want to count the number of times 22-9-2014 occurs in a range?:
=COUNTIF(A1:A30,"=22-9-2014")
or you can use an additional column to check if the date matches your criteria with this formula:
=IF(AND(WEEKNUM(A1)=39,WEEKDAY(A1)=2),1,0)
If the date is a Monday in week 39 then the cell shows a 1, you can then add all the 1's to get a total.
Is this what you were looking for?
Best regards,
Trowa
So you want to count the number of times 22-9-2014 occurs in a range?:
=COUNTIF(A1:A30,"=22-9-2014")
or you can use an additional column to check if the date matches your criteria with this formula:
=IF(AND(WEEKNUM(A1)=39,WEEKDAY(A1)=2),1,0)
If the date is a Monday in week 39 then the cell shows a 1, you can then add all the 1's to get a total.
Is this what you were looking for?
Best regards,
Trowa
doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
Sep 29, 2014 at 11:49 AM
Sep 29, 2014 at 11:49 AM
very good - thank you...!
