Amend formula

[Geo Jul]

Dear All

How do I amend the formula when I copy down to show only February?

=IF(ROWS(A$6:A6)>DAY(EOMONTH($C$5,0)),"",WORKDAY.INTL(C5,1,"0000110"))

Thank you in advance for your help

 

[bebo021999]

Book3.xlsm
	C
5	01-Feb
6	02-Feb
7	05-Feb
8	06-Feb
9	07-Feb
10	08-Feb
11	09-Feb
12	12-Feb
13	13-Feb
14	14-Feb
15	15-Feb
16	16-Feb
17	19-Feb
18	20-Feb
19	21-Feb
20	22-Feb
21	23-Feb
22	26-Feb
23	27-Feb
24	28-Feb
Sheet3

Cell Formulas
Range	Formula
C6:C24	C6	=IF(C5="","",IF(MONTH(WORKDAY.INTL(C5,1,7))>2,"",WORKDAY.INTL(C5,1,7)))

 

[Peter_SSs]

What range have you shown in your image?
What is in C5, C6, C7 etc?

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. We could then also see rows, columns, formulas etc.

 

[Geo Jul]

Book3.xlsm
	C
5	01-Feb
6	02-Feb
7	05-Feb
8	06-Feb
9	07-Feb
10	08-Feb
11	09-Feb
12	12-Feb
13	13-Feb
14	14-Feb
15	15-Feb
16	16-Feb
17	19-Feb
18	20-Feb
19	21-Feb
20	22-Feb
21	23-Feb
22	26-Feb
23	27-Feb
24	28-Feb
Sheet3

Cell Formulas
Range	Formula
C6:C24	C6	=IF(C5="","",IF(MONTH(WORKDAY.INTL(C5,1,7))>2,"",WORKDAY.INTL(C5,1,7)))

Thank you very Much for your help

 

[Geo Jul]

What range have you shown in your image?
What is in C5, C6, C7 etc?

BTW, I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with. We could then also see rows, columns, formulas etc.

Thank you; it has been resolved.

 

[Peter_SSs]

Thank you; it has been resolved.

Do you really only want dates for February? What if C5 was 1 March?
What about this for any month, and no need to copy down.

23 11 09.xlsm
	C
5	1/02/2023
6	2/02/2023
7	5/02/2023
8	6/02/2023
9	7/02/2023
10	8/02/2023
11	9/02/2023
12	12/02/2023
13	13/02/2023
14	14/02/2023
15	15/02/2023
16	16/02/2023
17	19/02/2023
18	20/02/2023
19	21/02/2023
20	22/02/2023
21	23/02/2023
22	26/02/2023
23	27/02/2023
24	28/02/2023
25
Workdays

Cell Formulas
Range	Formula
C6:C24	C6	=LET(d,WORKDAY.INTL(C5,SEQUENCE(30),7),FILTER(d,MONTH(d)=MONTH(C5)))
Dynamic array formulas.

 

[Geo Jul]

Do you really only want dates for February? What if C5 was 1 March?
What about this for any month, and no need to copy down.

23 11 09.xlsm
	C
5	1/02/2023
6	2/02/2023
7	5/02/2023
8	6/02/2023
9	7/02/2023
10	8/02/2023
11	9/02/2023
12	12/02/2023
13	13/02/2023
14	14/02/2023
15	15/02/2023
16	16/02/2023
17	19/02/2023
18	20/02/2023
19	21/02/2023
20	22/02/2023
21	23/02/2023
22	26/02/2023
23	27/02/2023
24	28/02/2023
25
Workdays

Cell Formulas
Range	Formula
C6:C24	C6	=LET(d,WORKDAY.INTL(C5,SEQUENCE(30),7),FILTER(d,MONTH(d)=MONTH(C5)))
Dynamic array formulas.

First thank you very much respones and your great formula yes this is what i need
but I am using 365 Excel, but in our office, some are still using 2016. Is it possible? to modify your formula to be used in excel 2016

 

[Peter_SSs]

Is it possible? to modify your formula to be used in excel 2016

It would need to be one that is copied down, but this should work for any month.

23 11 09.xlsm
	C
5	1/02/2023
6	2/02/2023
7	5/02/2023
8	6/02/2023
9	7/02/2023
10	8/02/2023
11	9/02/2023
12	12/02/2023
13	13/02/2023
14	14/02/2023
15	15/02/2023
16	16/02/2023
17	19/02/2023
18	20/02/2023
19	21/02/2023
20	22/02/2023
21	23/02/2023
22	26/02/2023
23	27/02/2023
24	28/02/2023
25
26
27
28
Workdays (2)

Cell Formulas
Range	Formula
C6:C28	C6	=IF(C5="","",IF(MONTH(WORKDAY.INTL(C5,1,7))<>MONTH(C$5),"",WORKDAY.INTL(C5,1,7)))

 

[Geo Jul]

It would need to be one that is copied down, but this should work for any month.

23 11 09.xlsm
	C
5	1/02/2023
6	2/02/2023
7	5/02/2023
8	6/02/2023
9	7/02/2023
10	8/02/2023
11	9/02/2023
12	12/02/2023
13	13/02/2023
14	14/02/2023
15	15/02/2023
16	16/02/2023
17	19/02/2023
18	20/02/2023
19	21/02/2023
20	22/02/2023
21	23/02/2023
22	26/02/2023
23	27/02/2023
24	28/02/2023
25
26
27
28
Workdays (2)

Cell Formulas
Range	Formula
C6:C28	C6	=IF(C5="","",IF(MONTH(WORKDAY.INTL(C5,1,7))<>MONTH(C$5),"",WORKDAY.INTL(C5,1,7)))

again, many thanks Your formula is very helpful.
regards

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.