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 03, 2015.

For more resources for Microsoft Excel