I have a date in cell A1. Cell B1 and B2 are two other dates. If A1 date is inbetween B1 and B2 dates, then need in B3 cell the data in B5, otherwise B6.
kindly suggest a solution.