i want to count how many mondays, tues, wed, thurs and fri do i have in total between a1 - a1080

what is the best formula to use?

thank you :)

Somewhere on your sheet you are going to need a list of the Days of the Week

I have put them in cells C1 - C7So your data should look something like:

A B C D 1) 02/27/13 Monday 2) 02/28/13 Tuesday 3) 03/01/13 Wednesday 4) 03/02/13 Thursday 5) 03/03/13 Friday 6) 03/04/13 Saturday 7) 03/05/13 Sunday 8) 03/06/13 9) 03/07/13 10) 03/08/13Now, in cell D1 enter the formula:

=SUMPRODUCT(--(TEXT($A$1:$A$1080,"DDDD")=C1))

and drag the formula down six rows.

This should give you what your looking for.

MIKE

Ask Your Question

Weekly Poll