I need a formula for three seperate cells that will populate the data from a 4th cell provided the date given is within a range specified for each of the three. I've attempted a snapshot for better explanation.
If so you wrote them out fine in words and this is what it looks like in excel
Basically the countif counts the number of times that the value in b5 appears in range 1. The if statements simply checks to see if that is >0 and if it is sets the value to a5, otherwise sets it equal to blank.
=IF(AND(b5>=K6,b5<=K7),a5,"") This acctualy works when k6 and k7 set the early and late dates of the range. To add the formula to the other cells I used k8 & k9 for the second range not overlapping the dates.