I am trying to check if “Entry Date” falls between range from Excel (example below).
Headers in my spreadsheet are dates. What I would like to achieve is to check whether my Entry Date exist in scope between keyword. In this example the keyword is “Payment”. So, for example Entry Date would be 23/09/2019, so it exist in given scope between “Payment” keyword (highlighted on red). However, if it does not exist then I have to loop forward and check if it exist in next scope (highlighted on green). Do you have any ideas how to do this?
Thank you in advace,