need help using a lookup or index function

I need to lookup a value in a column and return a value 3 cells down from that value. I've poured over the help functions, but I can't find any way to do this. For example:

1/6/2015
2/9/2015
3/16/2015
4/16/2015
5/21/2015
6/24/2015
8/6/2015

If I lookup the 1/6/2015 date, I need to have the 4/16/2015 date returned. If I lookup the 2/9/2015 date I need to eh 5/21/2015 date returned.

Need this for a project I'm working on, so any help would be appreciated! Thanks.

Please Login or Register  to view this content.

(B1 holds date to lookup)