Auto Populate Data based on Start & End Date

=IF(AND(K$2>=$G255,K$2<=$H255),$I255,"")   With the current formula above, I have to enter the "End Date" in order for it to populate. I would like for it populate when the End Date is blank, then ...