Getting a date from week number and year

[jonybandana]

Hi, I have a table as follows:

Week	Year
12	23
04	23
23	23
41	23
44	23
51	23

I would like to turn those numbers into dates in a third column, using the DATE Function, but I can´t, because I don´t have a week number to input.

How can I do this? I would like the date to represent the last day of that week.

Thank you!

PD: I would only like to "Reverse" The ISOWEEKNUM Formula, because all the dates are within the same year anyways.

 

[KRice]

Give this a try:

MrExcel_20230607.xlsx
	A	B	C
1	Week	Year	End of Week
2	12	23	3/26/2023
3	4	23	1/29/2023
4	23	23	6/11/2023
5	41	23	10/15/2023
6	44	23	11/5/2023
7	51	23	12/24/2023
Sheet12

Cell Formulas
Range	Formula
C2:C7	C2	=WORKDAY.INTL(("1-"&2000+B2)-1,1,"1110111")+3+7*(A2-1)

ISOWEEKNUM weeks begin on Monday, so last day of week is Sunday, and week 1 is assigned to the first week containing Thursday. Formula finds the 1st Thursday of the year (note 2000 is added to your shorthand year description--23 in these examples), and then 3 days are added to find the end of the 1st ISO week. Then the number of days for week number -1 is added to find the date for the desired end of the week.

 

[Herakles]

=DATE(B1,1,A1*7-(DAY(DATE(B1,1,1)+7-WEEKDAY(DATE(B1,1,1),2)))+1)

A1 = Week number
B1 = Year