Forum Discussion
Last 6 months
Hey,
I am tracking the number of falls for about 100 people, but need to know how many falls each have had in the last 6 months. I would like for this number to automatically update with the current date.
I have the months set across C1:N1 and the people B2:B100. Column O has each persons individual yearly total.
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.
