Counting weekdays in specific months

[cole416]

Hi all, I am trying to calculate from 1/2023 to 11/2032 how many weekdays there are in each month between those dates. I basically just have a row right now listing out each month and was trying to get a formula that would just go down each row in a column to the right of the dates.

I keep seeing solutions for workdays, but I need specifically weekdays M-F to be counted, i dont care about holidays. I can then just subtract that from the total amount of days in each month to get the weekends, so my focus is really on just the weekdays.

Let me know if I need to provide more information.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1	Date	weekdays	weekends
2	01/01/2023	22	9
3	01/02/2023	20	8
4	01/03/2023	23	8
5	01/04/2023	20	10
6	01/05/2023	23	8
7	01/06/2023	22	8
8	01/07/2023	21	10
9	01/08/2023	23	8
10	01/09/2023	21	9
11	01/10/2023	22	9
12	01/11/2023	22	8
13	01/12/2023	21	10
Main

Cell Formulas
Range	Formula
B2:B13	B2	=NETWORKDAYS(A2,EOMONTH(A2,0))
C2:C13	C2	=NETWORKDAYS.INTL(A2,EOMONTH(A2,0),"1111100")

 

[cole416]

Worked absolutely perfectly. Thank you kind sir.

 

[Fluff]

You're welcome & thanks for the feedback.