Hi guys.
Need some help with the sample file that i attached. How do i get the first value in G column depending on the date to look for. For example in A1 i have the today´s date and in this case i need do look for the date in F column and the first value in G10:G15 interval, that is associated with F10 (merged cell). In this case the result should be 5.
Is this possible with a formula?
Thanks in advance
Sample 1.xls
Bookmarks