Previous Topic Next Topic

Count number of specific days (e.e. Monday)

Closed
Tommy Boy - Feb 24, 2010 at 04:23 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 24, 2010 at 04:41 AM
Hello,
I have a list of dates in a column, I have converted them into days of the week (Format, Cell, Custom, dddd) and now want to count the number of times one particualr day (e.g. Monday) appears in the list. If I use the function COUNTIF I get "0" as teh value in the cell is e.g. 21/3/2009, not the weekday. Thanks
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 24, 2010 at 04:41 AM

Assuming your range is a1:a9, then how about this

=SUMPRODUCT(1 * (WEEKDAY(ROW(INDIRECT(A1 & ":" & A9)), 2) =1))

0

Similar discussions

Can’t access settings for a few days lock out
Rak7 -
HelpiOS -

1 response
Counting cells containing only numbers
jutulu -
jutulu -

4 responses
this account will be disabled in 28 day you only have 28 days left to request a
Chandrakantmahire -
Treasurelove -

2 responses
This account will be disabled in 1 day Are you sure that you want to log out? Y
Usman -
dwebb -

1 response
how to count sentences in a paragraph..." using c language
gealon2024 -
indhu -

4 responses