Find the value corresponding to the latest day for a given week

[everblazing]

HI

I would appreciate any help as its been so long for me trying to figure out a way for this and i'm stuck.

I am trying to lookup value in column O where Column B is the highest day for the week commencing in cell AU2.

Column B has different dates.



Regards

 

[pecoflyer]

Cross posted without links https://www.mrexcel.com/forum/excel...alue-corresponding-latest-day-given-week.html

 

[bosco_yip]

Please read the forum rule regarding Cross-Posting :

Please Don't

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.

• If you do cross-post, please put that in your post.

• Also if you have cross-posted and get an answer elsewhere, have the courtesy of posting the answer here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.

Regards
Bosco