title: Monthly Average from Daily data in excel
body: <p>In column A I have the days dd/mm/yyyy and it goes all the way from now until year 2000. In column B I have numeric data specific to that date. How can I find the monthly averages for the data without having to do it for each month manually. Is there a formulae I can use and just scroll down to find the averages for each month. Thank you.</p>