Lookup formla to allocate a calendar date to a week based on a table

Hi all gurus,

Attached, a file where in column L, i am looking for a formula that assigns a week reference for the date input in column J. The formula should refer to the table in cells C3:E55 as a lookup range.

Is there a quick solution for this?

Thank you
S

Put in L4:

=INDEX($E$4:$E$55,MIN(IF(($J4>=$C$4:$C$55)*($J4<=$D$4:$D$55),MATCH(ROW($E$4:$E$55),ROW($E$4:$E$55)))))

and press F2 botton to open the formula, after that press all together CTRL+SHIFT+ENTER button, when succes you'll see curly brackets "{}" that enclosed the formula
Last step copied down as necessary

if still fail try follow this link

https://simpan.ugm.ac.id/s/SwOSHtMQsCINAVE

Thank you.

It worked.

Glad it worked