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.

Thank you. I will try it and let you know how it goes.

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/

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

Sorry about that. It wont let me upload the file it says it's to big.

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.

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.

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. 

Thank you so much.

I've been having the same problem. Thanks so much for the solution!