Hi,

I'm trying to do a sensitivity analysis of historical S&P Prices. Basically I'm trying to find the Max, Min, and Avg of historical prices via financial quarter. I've set up my sheet with individual dates dates since 9/2/1989 in the first column and all of the closing prices in the next column, along with columns for min, max, and avg to store the results.

Basically the trouble I've been having is I'm not sure how to segment the dates into financial quarters and only find the max, min, and avg of just those dates. For example between 6/1/1989-9/31/1989 I can find the S&P closed at its highest of $377.73. I can't, however, find a formula that I can pull through the entire list, that will find the max, min, and avg for the quarters that follow it.

Any help that could be offered would be greatly appreciated. Thanks