I have a table like this:
Which basically contains jobs I've done, the dates I did those jobs and how much that job made me.
I'd like to find out how much money I've made this week (current date is
09/10/2015), with Monday being the first day of each week and Sunday the last. Monday of this week was on
Above you can see the values I'd like to sum, because they were all jobs completed within this week.
I can't get anything closer than this:
which only sums the money I've made today, but I want the whole week; how can I sum all the money I've made in this week?