I hope someone can help.
I am struggling to upload the image to the post but it can be found here:
https://imgur.com/a/KJbTMg1
https://imgur.com/a/KJbTMg1
I am trying to get cell F6 to return a value from the range K4:U4 (it goes further than column U), so I want this to be a number 53-63 (or higher)
I want the formula to look up the date D6 and evaluate the range K4:U3 and find which week number it falls into, then return that.
So in this case D6 is 09/10/18, which falls between 62 and 63. If I csan somehow specify that the dates are week endings, it will know that this is then week 63, and 63 is returned.
There are formulas in K5:U10 which look up the week numbers and then spread the costs, also interested if there is a way to remove the need for week numbers and use the date? maybe a question for another thread!
many thanks in advance
