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

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History