Day of week

Numeric representation of the day of the week. MySQL or Excel 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 中傳回的日期星期幾