Data mining using dates

I downloaded the historic prices of the S&P and am trying to pick out, monthly prices, and yearly prices. The dates are formatted mm/dd/yyyy except without the zeros.
The cells are a2:a15950 for dates and e2:e15950 for the associated data points. and the new range a5. I tried it on my own and am really at a loss. Thanks!

Almir's picture

Unclear request

I can not understand your request. What does "and the new range a5" mean?