I need help figuring out what formula to use if I have an ID# and a date that falls within a range what is the date that corresponds to both those criteria

ID DATE RANGE Date
1956 11/29/2012 2/28/2013 1/13/2013
3000 11/29/2012 2/28/2013 1/13/2013
37999 11/29/2012 2/28/2013 1/13/2013
3609 11/29/2012 2/28/2013 1/13/2013
20057 11/29/2012 2/28/2013 1/13/2013
4140 11/30/2012 3/1/2013 1/14/2013
4143 11/30/2012 3/1/2013 1/14/2013

# 3000
Date 12/2/2012
Response: