count days in range

[namluke]

Hi,

If i have a date range of say

02/12/14 to 22/01/15

how would i count the number of mondays or tuesdays etc with that range?

[Fotis1991]

http://www.get-digital-help.com/2007...ay-in-a-range/

[namluke]

I would need it without a date range for it to look at

[MarvinP]

Hi namluke,

How about a custom function to do this problem?

Please Login or Register  to view this content.

[Fotis1991]

Look the second option(formula) in the link that i provided

[namluke]

Hi Fotis,

I dont get what the "D4:D" is doing in there

[Fotis1991]

Perhaps this one will be more useful

Please Login or Register  to view this content.

[AlKey]

Here is another solution courtesy of daddylongleggs

in C2

=INT(($B2-$A2-WEEKDAY($B2-(COLUMNS($A$1:A1)-1),2)+8)/7)

Row\Col	A	B	C	D	E	F	G	H	I
1	Start Day	End Day	MON	TUE	WED	THU	FRI	SAT	SUN
2	12/2/2014	1/22/2015	7	8	8	8	7	7	7