Count Specific day of the week between two dates

[andrewvanmarle]

Im currently using this lovely formula to count the week days between the dates listed in the two cells:

= -NETTO.WERKDAGEN(A6;B6)*F6

Werkdagen is the dutch version of Weekdays


Now I'd like to make something like this for someone else but count different days of the week (since their weekend is sunday monday)/
I though of a list with the days to be counted and then refer to that in a formula, but I honestly dont know where to start.

Would anyone like to help?

Thank you!

 

[Fluff]

No, we don't have anything like.

 

[andrewvanmarle]

shame, consider this a hero point from me : ?

 

[Fluff]

Thanks

 

[andrewvanmarle]

@Fluff

Last question: right now it counts up to the second date, can it be modified to count including the second date?

For instance entering the same day twice counted as one in my old calculation....


Thanks!

 

[Fluff]

It still does that

+Fluff v2.xlsm
	A	B	C
1
2	15/12/2020	15/12/2020	1
Week_List

Cell Formulas
Range	Formula
C2	C2	=IF(OR(A2="",B2=""),"",NETWORKDAYS.INTL(A2,B2,2,$H$2:$H$10))

 

[andrewvanmarle]

You're right, i must have in advertantly tried weekend days, sorry!

have another hero point! ?


by the way: would you know why a "" value interferes with the above formula? (in the H array?)

 

[Fluff]

Excel treats "" as text which is why it will cause a problem, as the formula is expecting dates rather than text.

 

[andrewvanmarle]

Fixed it, I made the value zero. that turns in to 1-1-1900 which doesnt interfere with the formula

 

[Fluff]

Glad you sorted it & thanks for the feedback.