how about this sql how can I get the date range

"SELECT timestamp, SUM(name) AS tits FROM amount_data WHERE timestamp >= curdate() - interval 14 + weekday(curdate()) - 0 DAY and timestamp < curdate() + interval - weekday(curdate()) - 7 DAY";