How about something like:
```
select enddate,
sum(...),
...
from (
select date(cast(julianday(datecolumn)-1721061.5 as integer)/7*7+1721067.5) as enddate,
*
from theTable
)
group by enddate
order by enddate;
```