Determining the number of working days in a week

Dear experts,

I need help in determining the number of working days in a week, as I am currently having trouble figuring it out.

For example, in January 2024, the working days are as follows:

Week 1: 4 working days (1/1 is a holiday)
Week 2: 5 working days
Week 3: 5 working days
Week 4: 5 working days
Week 5: 3 working days (as the month ends on a Wednesday)

ADD: I would like to input the month (January-24) or the period (01/01/2024 to 31/01/24) and receive the number of working days per week.

Could you please provide me with advice on how to properly organize this information?

Thank you.

You indicated that your MS-Off Ver is google planilhas, but there is no MS-Off Ver with that name.
If you need a solution for Google sheets please move your thread to the forum for Google sheets (by reporting your own post).

This solution works in Excel 2021 en Excel 365.

Please enter a date of the month in A2, the holidays in column D and try in B2:

Formula:

Please Login or Register  to view this content.

MS-Off Ver: google planilhas?

The thread has been moved. Do NOT open another thread! Thanks.

Thanks for the feedback and rep .

I'll try to convert this formula for Google Sheets.

This formula should work in Google sheets (English with separate char ", "):

Please enter the holidays from D2, a date of the month in A2 and try:

Formula:

Please Login or Register  to view this content.

Link: https://docs.google.com/spreadsheets...it?usp=sharing