Log In
Register
Home
January 7, 2020
Offline
I track project for work. For example, the beginning of the month of June would be May 29th through June 28th. Everything between those dates would be counted as June projects.
I am a novice and have tried to do this to no avail.
I am more than willing to learn if someone wants to walk me through this.
Trusted Members
February 13, 2021
Offline
Hi Charles,
We have similar cut off dates at work, I have a spreadsheet where I set the months and their cut-off in a table and used an array formula to find the months. Please see attached sheet, the array is in cell D2. This is an array formula, so you will need to enter with ctrl+shift+enter in order for it to work properly if you are working in excel 2019 or under.
January 7, 2020
Offline
Thank you. I will try it and let you know how it goes.
January 7, 2020
Offline
I added that array. Still not getting the totals.rnIf you look on the Month totals tab. This is where I am trying to get it to work.rn rnThank you for helping me on this. I have been working on this in my spare time for over a year.
The Complete tab is where I enter the dates/
July 16, 2010
Offline
Hi Charles,
You didn't upload your file. After selecting the file, click the 'start upload' button and wait for the grey tick beside the file size to make sure it has completed uploading before posting your reply.
Mynda
January 7, 2020
Offline
Sorry about that. It wont let me upload the file it says it's to big.
July 16, 2010
Offline
Please share a link to it on DropBox or OneDrive or similar online file storage facility. Or even better, just create a small sample file that illustrates your issue.
January 7, 2020
Offline
Here is a scaled down version.
The month totals tab is were you will see the count from the complete tab.
I am trying to get the totals to count from the 29th to the 28th of a month. I.e 29 Dec 2020 to 28 Jan 2021 will count for all of January totals and so on.
Trusted Members
February 13, 2021
Offline
Hi Charles!
So I took your data and in the "Completed" tab I added a new column for Month Completed, using helper data on the same sheet with your days to calculate the months in your cut-off period and updated your pivot to use that column instead of the "Date Completed" column. I hope this helps, or points you in the direction you are looking to go.
1 Guest(s)
