Date & time › WEEKDAY, IF69 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

MediumFreeWEEKDAYIF

WEEKDAY: double pay for weekend overtime

Mr. Joko, the foreman of a house renovation project in Depok, pays the builders Rp25,000 per hour of overtime. Overtime on a Saturday or Sunday is paid double. He records the date and the overtime hours, but not the day of the week.

Task

Fill C2:C8 with the overtime pay: overtime hours (column B) × the hourly rate in F1, multiplied by 2 if the date (column A) falls on a Saturday or Sunday. Use WEEKDAY and IF.

Cells to fillC2:C8

Required functionsWEEKDAYIF

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
WEEKDAY(date, 2) returns a day number from Monday = 1 to Sunday = 7. So Saturday and Sunday are 6 and 7.
Hint 2
Build the multiplier with IF: 2 if the day number is greater than 5, otherwise 1. Lock the rate with $F$1.
Hint 3
Pattern: =B2 * $F$1 * IF(WEEKDAY(…, 2) > 5, …, …).

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

C2:C8

=B2*$F$1*IF(WEEKDAY(A2,2)>5,2,1)

Write it in C2, then fill down to C8.

Explanation

=B2*$F$1*IF(WEEKDAY(A2,2)>5,2,1) uses type 2 so the weekend check is simply >5. Without the second argument, WEEKDAY uses type 1 (Sunday = 1, Saturday = 7), so >5 would wrongly flag Friday and miss Sunday. Tip: the cell format dddd shows the weekday name without changing the date value, which is handy for checking results.

Starting worksheet: Sheet1
Row	A	B	C	E	F
1	Date	Overtime hours	Overtime pay	Hourly rate	25,000
2	02/10/2026	3
3	03/10/2026	5
4	04/10/2026	4
5	06/10/2026	2
6	09/10/2026	3
7	10/10/2026	6
8	12/10/2026	2
9
10
11
12
13
14

Fill in the requested cell, then press Check answer.

Validation result