Excel's WEEKDAY function returns a number from 1-7 or 0-6.

Question

Quizplus · Accepted Answer

The WEEKDAY function in Excel returns a number from 1-7 or 0-6, depending on the optional second argument that specifies the first day of the week. By default, if no second argument is provided, the function assumes Sunday as the first day of the week and returns a value between 1 (Sunday) and 7 (Saturday). However, if the second argument is set to 2, the function treats Monday as the first day of the week and returns a value between 1 (Monday) and 7 (Sunday).

Excel's WEEKDAY Function Returns a Number from 1-7 or 0-6