SQL Query- field calculation based on date
One solution to this problem would be to create a static calendar table. In the scope of your problem, this table would be important because there are holidays that must be considered when calculating the week's goals, as it is not fair to compare the targets an entire week with a partial week (holidays).

The downside of these static tables is proper management and organization of the calendar for the New Year's and holidays change. It is very important to put reminders in this routine to minimize the chance of a possible future problem.

Consider this risk for the proposed solution.