Get date from Week number and day

[Weeble]

Week	Day	Date
22	2	2021-06-02
22	2	2021-06-03
23	1	2021-06-07

I'm trying to find a formula where I would get the date in 3 third column as shown above.
I have first two columns , Week and Day. Is there a formula that could transform it into a complete date?

 

[Joe4]

Have a look here: Converting Week Number to Date - Free Excel Tutorial

 

[jasonb75]

There is no obvious logic to the example other than the last entry. See if this helps (based on @Tetra201's suggestion from an earlier post).

Book1
	A	B	C	D
2	22	1		31-May-21
3	22	2		01-Jun-21
4	22	3		02-Jun-21
5	22	4		03-Jun-21
6	22	5		04-Jun-21
7	22	6		05-Jun-21
8	22	7		06-Jun-21
9	23	1		07-Jun-21
10	23	2		08-Jun-21
11	23	3		09-Jun-21
12	23	4		10-Jun-21
13	23	5		11-Jun-21
14	23	6		12-Jun-21
15	23	7		13-Jun-21
Sheet2

Cell Formulas
Range	Formula
D2:D15	D2	=WORKDAY.INTL(DATE(YEAR(TODAY()),1,0),A2,"1111110")+B2

 

[Weeble]

There is no obvious logic to the example other than the last entry. See if this helps (based on @Tetra201's suggestion from an earlier post).

Book1
	A	B	C	D
2	22	1		31-May-21
3	22	2		01-Jun-21
4	22	3		02-Jun-21
5	22	4		03-Jun-21
6	22	5		04-Jun-21
7	22	6		05-Jun-21
8	22	7		06-Jun-21
9	23	1		07-Jun-21
10	23	2		08-Jun-21
11	23	3		09-Jun-21
12	23	4		10-Jun-21
13	23	5		11-Jun-21
14	23	6		12-Jun-21
15	23	7		13-Jun-21
Sheet2

Cell Formulas
Range	Formula
D2:D15	D2	=WORKDAY.INTL(DATE(YEAR(TODAY()),1,0),A2,"1111110")+B2

Thank you! it worked.

I had no idea this would be so hard to find a solution for. You would think there was an easier way to write out a date when you have week and day and if you just provided it with a year in a cell.

 

[Dave Patton]

My example does that show the results per your table.
Check Excel's Help for the function.
Review my example; edit the formula to work with your requirements.
Check the results for week 1 and edit the last day of the previous year if necessary.

Workday.xlsm
	A	B	C	D	E	F
1	27-12-20	Mon 28-Dec-20
2	Mon 04-Jan-21	1		Week	Day	Date
3				22	1	Mon 31-May-21
4				22	2	Tue 01-Jun-21
5				22	3	Wed 02-Jun-21
6				22	4	Thu 03-Jun-21
7				22	5	Fri 04-Jun-21
8				23	1	Mon 07-Jun-21
9
2a

Cell Formulas
Range	Formula
A2	A2	=B1+7
B2	B2	=WEEKNUM(A2,21)
F3:F8	F3	=$A$1+E3+7*D3