Countifs

[jbaever]

I need to count the number of "Mondays" in a range of dates that is custom formatted to include the day of the week. The range of dates is in B3:B46. The criteria is in D2 (text form). I have tried countifs, countifs with match, countifs with text

 

[T. Valko]

I need to count the number of "Mondays" in a range of dates that is custom formatted to include the day of the week. The range of dates is in B3:B46. The criteria is in D2 (text form). I have tried countifs, countifs with match, countifs with text

Maybe this...

If D2 = the long weekday name like Monday:

=SUMPRODUCT(--(TEXT(B3:B46,"dddd")=D2))

If D2 = the short weekday name like Mon:

=SUMPRODUCT(--(TEXT(B3:B46,"ddd")=D2))

 

[jbaever]

Thank you, that worked. Just did not think to use sumproduct.

 

[T. Valko]

Thank you, that worked. Just did not think to use sumproduct.

Good deal. Thanks for the feedback!