Hello,
I am trying to average a list of numbers in the second table based on which quarter and year they fall into. 1st quarter of 2003 corresponds in the table below to 1/01/2003, 2nd quarter of 2004 is 4/04/2014, etc. In my second column I am trying to get an average of the second column of the second table below based on if the month is 1 2 or 3 for 1st quarter, 4 5 or 6 for second quarter, etc. and if the year matches the year in the Quarter column. Any Ideas?
<TBODY>
</TBODY>
<TBODY>
</TBODY>
I am trying to average a list of numbers in the second table based on which quarter and year they fall into. 1st quarter of 2003 corresponds in the table below to 1/01/2003, 2nd quarter of 2004 is 4/04/2014, etc. In my second column I am trying to get an average of the second column of the second table below based on if the month is 1 2 or 3 for 1st quarter, 4 5 or 6 for second quarter, etc. and if the year matches the year in the Quarter column. Any Ideas?
Quarter | Average Return for the Quarter |
1/01/2003 | |
4/01/2004 |
<TBODY>
</TBODY>
Date | Return |
1/4/2003 | 127 |
2/5/2003 | 120 |
4/3/2004 | 159 |
5/23/2004 | 161 |
<TBODY>
</TBODY>