Forum Discussion
Last 6 months
Send that excel file.
Or give an example.
I cant send the file due to confidentiality issues, but this is essentially what it looks like:
I would like for column P to have the total for the last 6 months, that would change with the current date (ex - today is May 23 so i would want the total for November 23-Dec 23, when I open the file in June, I'd like the total to be for Dec-May)
Okay.
But, see.
As per screen shot, You have provided a sheet having particulars for 'Jan - Dec'. It look like 'Jan 2017 - Dec 2017', same year.
If you want to add last 6 months total, you need 'Nov 2016, Dec 2016, Jan 2017, Feb 2017, Mar 2017, Apr 2017'.
But for particulars for 4 months only available. Where is Nov 2016, Dec 2016?
Because you have specified that you need 'last 6 months total'.
That is the only thing confusing me.
Clarify this.
it shouldnt matter if my screenshot doesnt have the data for the last 6 months - pretend it is october today. or even if it was for just the last 4 months - I would just need to change a portion of the formula?
