Hi there,
I have one year of Dates between B2:OF2
I have one year of Data between B6:OF6
In one cell I would like to take the average of data from months between November 1 - March 31.
In another cell I would like to take the average of data from months between April 1 - Oct 31.
The spreadsheet will continuously have one year of data so right now the spreadsheet has April 1, 2020 to April 30, 2021. Next month I'll drop April 2020 and add May 2021. So I'm hoping to do this without having to adjust the formula going forward.
Thanks for your help.