Weekdays only for 1 Month

[itsgrady]

Need help.

In C5 I have a date (10/1/24)

Need to list weekdays of October only. In column B, starting in B8, I would like to list all weekdays (Monday - Friday) of the month in C5. I need the formula to stop after the month given in C5 (don’t list or show November).

If the month starts on a Saturday or Sunday don’t list that date. Just start with the first weekday.

I tried working on a formula (see below) but it gives all dates for the month and I can’t figure it out. Thanks for any help.

=IF(WEEKDAY(DATE(YEAR($C$5),MONTH($C$5),1))=1, DATE(YEAR($C$5),MONTH($C$5),2), DATE(YEAR($C$5),MONTH($C$5),1)) + ROW(A1) - 1

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2
3
4
5			01/10/2024
6
7
8		01/10/2024
9		02/10/2024
10		03/10/2024
11		04/10/2024
12		07/10/2024
13		08/10/2024
14		09/10/2024
15		10/10/2024
16		11/10/2024
17		14/10/2024
18		15/10/2024
19		16/10/2024
20		17/10/2024
21		18/10/2024
22		21/10/2024
23		22/10/2024
24		23/10/2024
25		24/10/2024
26		25/10/2024
27		28/10/2024
28		29/10/2024
29		30/10/2024
30		31/10/2024
31
Data

Cell Formulas
Range	Formula
B8:B30	B8	=WORKDAY(C5-1,SEQUENCE(NETWORKDAYS(C5,EOMONTH(C5,0))))
Dynamic array formulas.

 

[itsgrady]

How about

Fluff.xlsm
	A	B	C
1
2
3
4
5			01/10/2024
6
7
8		01/10/2024
9		02/10/2024
10		03/10/2024
11		04/10/2024
12		07/10/2024
13		08/10/2024
14		09/10/2024
15		10/10/2024
16		11/10/2024
17		14/10/2024
18		15/10/2024
19		16/10/2024
20		17/10/2024
21		18/10/2024
22		21/10/2024
23		22/10/2024
24		23/10/2024
25		24/10/2024
26		25/10/2024
27		28/10/2024
28		29/10/2024
29		30/10/2024
30		31/10/2024
31
Data

Cell Formulas
Range	Formula
B8:B30	B8	=WORKDAY(C5-1,SEQUENCE(NETWORKDAYS(C5,EOMONTH(C5,0))))
Dynamic array formulas.

Thank you so much for a great solution to my problem. As always, your help is greatly appreciated. Have fun today!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[itsgrady]

How can I list all day for that month? Your formula is a lot more concise than mine. Thanks.

 

[Fluff]

How about

=C5+SEQUENCE(DAY(EOMONTH(C5,0)),,0)

 

[itsgrady]

How about

=C5+SEQUENCE(DAY(EOMONTH(C5,0)),,0)

Excellent. Thanks.

 

[Fluff]

My pleasure.