Return weekday only for a given month

[itsgrady]

I want to exclude the last day of the previous month and only display the weekdays of the specified month in cell B7. The formula below shows the last weekday of the pervious month. Only need to show the month in cell B7.

Can I get help to show only a list of all the weekdays of the month typed in B7?

I envision that you can type 11-1 in B7 and in a column A will display all Mondays-Fridays dates of the given month.

=IF(WEEKDAY(DATE(YEAR($B$7),MONTH($B$7),ROW(A1)))=2,DATE(YEAR($B$7),MONTH($B$7),ROW(A1)),IF(OR(WEEKDAY(DATE(YEAR($B$7),MONTH($B$7),ROW(A1)))=1,WEEKDAY(DATE(YEAR($B$7),MONTH($B$7),ROW(A1)))=7),DATE(YEAR($B$7),MONTH($B$7),ROW(A1))+2,DATE(YEAR($B$7),MONTH($B$7),ROW(A1))-1))

 

[Fluff]

How about

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

Cell Formulas
Range	Formula
A7:A28	A7	=WORKDAY(B7-1,SEQUENCE(NETWORKDAYS(B7,EOMONTH(B7,0))))
Dynamic array formulas.

 

[itsgrady]

How about

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

Cell Formulas
Range	Formula
A7:A28	A7	=WORKDAY(B7-1,SEQUENCE(NETWORKDAYS(B7,EOMONTH(B7,0))))
Dynamic array formulas.

Excellent! Fantastic! Wonderful! Outstanding! Marvelous! Great!

Thanks for the quick - Kudos.

 

[Fluff]

You're welcome & thanks for the feedback.