I have 2 columns one with dates (D7:D37) and another with values
corresponding to the dates in the same row(E7:E37). I actually need 2
examples. I'd like to see the date in D column prior to the date that is 6
months prior to today with the corresponding value and in addition i hope to
be able to see the 1st date in columnd D that is after 6 months prior to
today and it's corresponding value. I'm trying to put these values in A41 and
B 41 and A42 and B42. Thanks for your help!