Day of week

Numeric representation of the day of the week. MySQL, Excel or PHP approaches to specify these date time.

Weekday

Day	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Weekday (ISO-8601 PHP date N character)	7	1	2	3	4	5	6
Weekday (MySQL)	6	0	1	2	3	4	5
Weekday (Excel)	1	2	3	4	5	6	7
Weekday (PHP date w character)	0	1	2	3	4	5	6

Day	Sunday	Monday	Tuesday	Wednesday	Thursday	Friday	Saturday
Last week	MySQL: SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())-6						PHP: (1) echo date('Y-m-d', strtotime("last Saturday")) . PHP_EOL; (2) echo date('Y-m-d', strtotime('last Saturday', strtotime("2018-03-04 00:01:00"))) . PHP_EOL;
This week	MySQL: SELECT CURDATE() + INTERVAL -1 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+1	MySQL: SELECT CURDATE() + INTERVAL 0 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+2	MySQL: SELECT CURDATE() + INTERVAL 1 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+3	MySQL: SELECT CURDATE() + INTERVAL 2 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+4	MySQL: SELECT CURDATE() + INTERVAL 3 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+5	MySQL: SELECT CURDATE() + INTERVAL 4 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+6	MySQL: SELECT CURDATE() + INTERVAL 5 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+7 PHP: echo date('Y-m-d', strtotime("Saturday")) . PHP_EOL;
Next week	MySQL: SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+8