Separating Table by Week
I am working on a project where I am pulling in employee utilization totals from sheets being populated by data shuttle on a bi-weekly basis to a table that calculates totals.
The cloumns are basically using SUMIFs to populate the totals but I'm running into an issue where I can't separate these totals by week. I have the week number being calculate by month on the source sheets using this forumla.
=ROUNDUP((WEEKDAY(DATE(YEAR([Event Date]@row), MONTH([Event Date]@row), 1)) + DAY([Event Date]@row)) / 7)
This basically returns 1-5 depending on the week of month.
I need to be able to filter out by weeks 1-5 or some combination of them like weeks 1 and 2 or 3 and 4 etc.
I can't find an effective way to do this. you can see on the left where under week number I tried to play with the formula to read whatever number they put in that cell but I can't do multiple weeks this way and I don't think it's a scalable solution.
Here is a screenshot of one of the source sheets as well, they are all pretty similar.
Help Article Resources
Check out the Formula Handbook template!