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?


[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

1​

[/td][td]

71​

[/td][td]

2018​

[/td][td]

19​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

2​

[/td][td][/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

5/7/2018​

[/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

5/14/2018​

[/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

5​

[/td][td]

5/21/2018​

[/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

6​

[/td][td]

5/28/2018​

[/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

7​

[/td][td]

6/4/2018​

[/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

8​

[/td][td]

6/11/2018​

[/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

9​

[/td][td]

6/18/2018​

[/td][td][/td][td][/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

10​

[/td][td]

6/25/2018​

[/td][td][/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet15[/td][/tr][/table]

A3 Formula:[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

3​

[/td][td]

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

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet15[/td][/tr][/table]


A4 Formula and copy down:
Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#E0E0F0][th] [/th][th]

A​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#E0E0F0]

4​

[/td][td]

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

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet15[/td][/tr][/table]