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!