If cell B3 is between range C1 to C5 and date in cell to right is between 16th and 18th march

[jeremypyle]

If cell B1 is between range C1 to C5 and date in cell to right is between 16th and 18th march then "y" otherwise "n"

I can't figure this one out. If b1 is between c1 to c5, then answer is yes only if the date to the right of the searched field in the c column has a date to the right that is between 16 and 18th march.

In this case, the answer would be "y". But if cell c3 had the figure 3 in it but the date to the right was 20th march, then the answer would be "n"

Can anyone figure this out?

 

[Peter_SSs]

Your link does not work for me. In any case posting a small set of sample data directly here in your post will get you many more potential helpers since they do not have to navigate to another site and the data posted here can be copied to a worksheet for testing. My signature block below contains 3 methods for doing that. Test them in the Test Here forum. That way, if something goes wrong, you won’t be messing up a main forum.