0
0
Google Sheetsspreadsheet~10 mins

WEEKDAY and WORKDAY in Google Sheets - Cell-by-Cell Formula Trace

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Sample Data

Dates in column A and numbers of days to add in column B

CellValue
A12024-06-10
A22024-06-14
A32024-06-15
B15
B22
B33
Formula Trace
=WEEKDAY(A1, 2)
Step 1: A1
Step 2: WEEKDAY("2024-06-10", 2)
Cell Reference Map
2024-06-10
↓
2024-06-14
↓
2024-06-15
The formula references cell A1 which holds the date to find the weekday for.
Result
    A           C
1 2024-06-10    1

Cell C1 shows the weekday number for the date in A1
The formula result '1' means Monday, as per WEEKDAY with type 2 numbering.
Sheet Trace Quiz - 3 Questions
Test your understanding
What weekday number does WEEKDAY(A1, 2) return if A1 is 2024-06-10?
A1
B2
C7
D5
Key Result
WEEKDAY(date, type) returns the day number of the week; WORKDAY(start_date, days) returns the date after adding workdays skipping weekends.