Hello,
I have 9 years of daily stock data (January 1, 2006 to December 31, 2014) in columns from B2 to B2266 (daily dates are in A column). I would like to find and list the average of each months daily data in columns D2 to D108 (monthly dates are in columns C 2 to C108). Is there an easier way to do this?
note: stock data is based on business days and doesn't include market holidays.
Thanks for you help
Dangles
Bookmarks