So I want to use a formula calculating a rolling 12 months, and rolling 24 months where the data is separated.
Data looks something like this:
Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17
Charges 100 100 100 100 100 100 100 100
In this example Dec - 17 ends in column P. Jan 2016 begins in Column U. How would I set up a formula to automatically add these 8 months and then the last 4 months of 2016 (Columns AC-AF). I'm assuming I need to add a date somewhere then run off that? This is something I will do every month. So next month I want to easily be able to update the formulas so that it pulls 9 months of 2017 and 3 months of 2016, etc..
Data looks something like this:
Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17
Charges 100 100 100 100 100 100 100 100
In this example Dec - 17 ends in column P. Jan 2016 begins in Column U. How would I set up a formula to automatically add these 8 months and then the last 4 months of 2016 (Columns AC-AF). I'm assuming I need to add a date somewhere then run off that? This is something I will do every month. So next month I want to easily be able to update the formulas so that it pulls 9 months of 2017 and 3 months of 2016, etc..
