Formula to find the dates only for Saturdays and Sundays

[Tija]

The employee will start a part time job only on weekends (Saturday and Sunday) for 16 days. He / She will be starting on April 23, 2022.
How to find the dates in the cell B7:B22 using a formula?

 

[Peter_SSs]

Welcome to the MrExcel board!

For the future, please consider the following to save helpers having to manually type out your sample data:
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

If this is not what you want then please post the sample data again (noting the comments above) but also include the expected results and any further explanation.

22 04 19.xlsm
	A	B
1		23-Apr-2022
2		Saturday
3
4
5
6
7	1	23-Apr-2022
8	2	24-Apr-2022
9	3	30-Apr-2022
10	4	01-May-2022
11	5	07-May-2022
12	6	08-May-2022
13	7	14-May-2022
14	8	15-May-2022
15	9	21-May-2022
16	10	22-May-2022
17	11	28-May-2022
18	12	29-May-2022
19	13	04-Jun-2022
20	14	05-Jun-2022
21	15	11-Jun-2022
22	16	12-Jun-2022
Weekends

Cell Formulas
Range	Formula
B2	B2	=TEXT(B1,"dddd")
B7	B7	=B1
B8:B22	B8	=B7+IF(WEEKDAY(B7)=7,1,6)

 

[Tija]

Thank you for your help. Appreciate it.

 

[Peter_SSs]

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

 

[Fluff]

As you have 365 another option that will spill down

+Fluff 1.xlsm
	A	B
1		23/04/2022
2		Saturday
3
4
5
6
7	1	23/04/2022
8	2	24/04/2022
9	3	30/04/2022
10	4	01/05/2022
11	5	07/05/2022
12	6	08/05/2022
13	7	14/05/2022
14	8	15/05/2022
15	9	21/05/2022
16	10	22/05/2022
17	11	28/05/2022
18	12	29/05/2022
19	13	04/06/2022
20	14	05/06/2022
21	15	11/06/2022
22	16	12/06/2022
23
Lists

Cell Formulas
Range	Formula
B2	B2	=TEXT(B1,"dddd")
B7:B22	B7	=WORKDAY.INTL(B1,SEQUENCE(16,,0),"1111100")
Dynamic array formulas.

 

[Tija]

Thank you Fluff. Highly appreciated.

 

[Fluff]

My pleasure