0
0
Excelspreadsheet~10 mins

WEEKDAY and WORKDAY in Excel - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Dates and numbers used to calculate weekdays and workdays. A1 and A3 contain the same start date. A2 and A4 contain the number of days to add.

CellValue
A12024-06-10
A23
A32024-06-10
A45
Formula Trace
WEEKDAY(A1, 2)
Step 1: WEEKDAY("2024-06-10", 2)
Cell Reference Map
2024-06-10
↓
3
↓
2024-06-10
↓
5
WEEKDAY formula uses cell A1 which contains the date 2024-06-10.
Result
2024-06-10
↓
3
↓
2024-06-10
↓
5
↓
1
The result 1 means Monday, the weekday of the date in A1 with Monday as day 1.
Sheet Trace Quiz - 3 Questions
Test your understanding
What day number does WEEKDAY(A1, 2) return if A1 is Monday?
A2
B7
C1
D0
Key Result
WEEKDAY(date, type) returns the day number of the week; WORKDAY(start_date, days) returns the date after adding workdays skipping weekends.