Most valuable professional
  • Hot Topics

Excel Counting a particular day in a list of dates

I cannot for the life of me get SUMPRODUCT(--(WEEKDAY(A2:A28)=6)) to work. I need a formula to count the number of fridays that apear in the lost. Can anyone point me in the right direction? There will also be empty cells in this range.

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of June 3, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel