I need help with some complex formula.
I need to populate values into D3:D18 with dates from the calendar I had built on the right side.
Each value in the calendar consist of W1, W2, W3.....W16.
Thus, if any values selected in the calendar is 'W1', it will populate into the Week 1.
W2 for Week2 and onwards.
Excel1.jpg
Excel2.jpg
Bookmarks