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]

Have a look at Networkdays.Intl, that allows you to specify weekends.

=NETWERKDAGEN.INTL(A2;B2;2)

 

[andrewvanmarle]

Thanks fluff!

It works! well, where I fill in dates, but where I dont I get 1 as a result (not 0)

something i should add?

And I had a look at the microsoft support page. it states I make a list of other dates (holidays) that it shouldnt count either, but it doesnt say how of course....


so close

 

[Fluff]

To specify holidays, just put them in a range somewhere (for instance H2:H10) & use

=IF(OR(A2="",B2=""),"",NETWORKDAYS.INTL(A2,B2,2,$H$2:$H$10))

 

[andrewvanmarle]

 =ALS(OF(A5="",B5=""),"",NETWERKDAGEN.INTL(A5,B5,2,$I$5:$I$12))

The range of holidays is in I5 to I12

I get an error message when pasting this? It says it's not a formula.... really wierd....

(i wish excell hadnt translated all it's formulas)

 

[Fluff]

You will need to use semi-colons, not commas.

If you ever need help translating a formula have a look here

Translator

The online tool for the translation of Excel formulas and functions from one language to another. Supports the replacement of argument separators, 35 languages and much more.

en.excel-translator.de

 

[andrewvanmarle]

Thank you!

I'll try it in the morning!

 

[andrewvanmarle]

It works!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[andrewvanmarle]

Does this forum have hero point to award?