First Monday date from week number over multiple years starting from week num other than 1

[DroZ3]

Hi there, first post here.

I did not find a direct match to my question, please direct me to the appropriate post if necessary.

I need to show the date of the first Monday for a specific number of weeks starting from a specific week from a specific year.

Example : first Monday of every week for the next 71 (71 in cell A1) weeks , starting in year 2018 (2018 in cell B1), starting with week 19 [(19 in cell C1)(2018 is implied)].
Because the number of weeks may be more than 52 and maybe the starting week can be more than 1, the formula has to deal with more than one year ; more than one year but consecutive years.

No VB, formula please.

Thanks in advance.

 

[iggy_]

is this what you are looking for?

	A​	B​	C​
1​	71​	2018​	19​
2​
3​	5/7/2018​
4​	5/14/2018​
5​	5/21/2018​
6​	5/28/2018​
7​	6/4/2018​
8​	6/11/2018​
9​	6/18/2018​
10​	6/25/2018​

Sheet: Sheet15

A3 Formula:

	A​
3​	=DATE(B1,1,8)-WEEKDAY(DATE(B1,1,6))+(C1-1)*7​

Sheet: Sheet15

A4 Formula and copy down:
Excel 2016 (Windows) 32 bit

	A​
4​	=IF(A3<($A$3+($A$1*7)),A3+7,"")​

Sheet: Sheet15