Solved how to count the total days

February 26, 2013 at 17:31:11
Specs: Windows 7
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 :)

See More: how to count the total days

Report •

#1
February 27, 2013 at 08:54:51
✔ Best Answer
Somewhere on your sheet you are going to need a list of the Days of the Week
I have put them in cells C1 - C7

So 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/13 

Now, 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

http://www.skeptic.com/


Report •
Related Solutions


Ask Question