This is exactly my point - the quotas are monthly not daily, but he's doing the wrong kind of work. He's putting his data into a daily format and then trying to extrapolate monthly information.
The right way to solve this problem is to find the exact thing you want - the precise last weekday of the month, the precise first weekday, and a precise weekday average - which is trivial with any decent date/time library. These would be the RIGHT kind of gymnastics. Tallying information by day and then running some kind of regression to approximate last-day traffic is a waste when you can just GET the last-day traffic.
The right way to solve this problem is to find the exact thing you want - the precise last weekday of the month, the precise first weekday, and a precise weekday average - which is trivial with any decent date/time library. These would be the RIGHT kind of gymnastics. Tallying information by day and then running some kind of regression to approximate last-day traffic is a waste when you can just GET the last-day traffic.