problem with calendar

[chriswrcg]

I have a calendar in my workbook that is supposed to be able to change the week of the year and display the date. So 9th Monday would be 2/26/2018. This works great when using week 1 through 9 but goes to pot when 10th week is changed. When I put in 10th Monday Excel is seeing 10th as the 1 week and displaying 1/1/2018 instead of 3/5/2018
any ideas how to change that?
Please see the example i have provided

[Glenn Kennedy]

Maybe this in G3,copied down:
=WORKDAY.INTL(($E$1&$F$1)-1,-LOOKUP(1,-LEFT(E3,{1,2,3,4,5,6,7,8,9,10})),LEFT(REPT(1,MATCH(F3,TEXT({2,3,4,5,6,7,8},"DDDD"),0)-1)&"0111111",7))

[chriswrcg]

Thank You. That works great.

[Glenn Kennedy]

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.