count days between dates without counting Fridays

[bkcffee]

example ,,,
someone came late from vacations
his vacation ends 16-12-2021
he resume to duty on 26-12-2021

I want to count late days which is (7 days) without counting fridays !!

thanks

[AliGW]

How do you arrive at 7? What else are you excluding???

This will count excluding Fridays AND Saturdays:

=NETWORKDAYS.INTL(A1,B1,"0000110")

and will return 7.

This will exclude just Fridays:

=NETWORKDAYS.INTL(A1,B1,"0000100")

but will NOT return 7.

[AliGW]

Maybe you are wanting to exclude the start and end dates of the range? If so, then this:

=NETWORKDAYS.INTL(A1,B1,"0000100")-2

or this:

=NETWORKDAYS.INTL(A1+1,B1-1,"0000100")

Some feedback would be nice.

[bkcffee]

let me check with more examples !!
but thanks ... i'll try them both !!

sorry for double posting but..
can you count fridays between these 2 dates ?

[AliGW]

Yes, you can:

=NETWORKDAYS.INTL(A1,B1,"1111011")

Basically a 1 means ignore the day, 0 means count it - the range starts on a Monday.

[bkcffee]

Thanks !! I'll check it out
I'm working on 2 systems + my Excel form
trying to compare between them all

[bkcffee]

Basically a 1 means ignore the day, 0 means count it - the range starts on a Monday.

ahh i get it now thanks

[AliGW]

It should work the same on any system.

In future, it would be better (and you've had this suggested to you before) to provide a workbook with several mocked-up examples of what you want (manually calculated). Then your helper can check that the solution offers fits your requirements fully. Otherwise we are working a bit in the dark.

[bkcffee]

Thanks AliGW

Im using this one =NETWORKDAYS.INTL(A1,B1,"0000100")-2 !!

[AliGW]

Great!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[bkcffee]

done and done !!