Please help:
I have a table
Basically I just need to return from list E1 When Dates are =D1 and <=F1
so
2/23 Tim
2/26 Tim....
3/2 Tom..
3/9 Mike

A1=(TODAY)
D1 E1 F1
23-Feb TIM 7-Jan
2-Mar TOM 14-Jan
9-Mar MIKE 21-Jan

The formula will be in
A2