Day of week

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

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
Last week	MySQL: SELECT CURDATE() + INTERVAL -8 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())-6
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
Next week	MySQL: SELECT CURDATE() + INTERVAL 6 - WEEKDAY(CURDATE()) DAY; Excel: =NOW()-WEEKDAY(NOW())+8

further reading

• PHP date function: w character (0 for Sunday through 6 for Saturday) or N character (1 for Monday through 7 for Sunday)
• WEEKDAY 函數 - Office 支援
• ISO 8601 - Wikipedia
• mysql - How to get this coming Sunday's date? - Stack Overflow
• 如何在 Excel 中傳回的日期星期幾