Formuladrill

Level 4: Text and dates Exercise 75 of 118

Weekend or weekday

An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.

The task

Label each date as Weekend (Saturday or Sunday) or Weekday. Fill B2 to B4.

What this exercise teaches

Without the second argument WEEKDAY starts the week on Sunday (Sunday is 1, Saturday is 7), and the weekend test becomes two separate checks. Type 2 puts both weekend days at the end.

A hint if you get stuck

WEEKDAY(date, 2) numbers Monday as 1 through Sunday as 7, so anything above 5 is a weekend.

Functions used: IF, WEEKDAY

Try it now, free, no account needed

Your first 15 exercises on Formuladrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro unlocks every exercise, timed mode and the certificate.

Open this exercise

More exercises in Text and dates