WEEKDAY and WORKDAY in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the WEEKDAY function do in Google Sheets?

The WEEKDAY function returns a number representing the day of the week for a given date. For example, Sunday can be 1, Monday 2, and so on, depending on the chosen return type.

beginner

How do you use the WORKDAY function in Google Sheets?

WORKDAY calculates a date that is a certain number of working days away from a start date, skipping weekends and optionally holidays.

beginner

What is the default weekend in the WORKDAY function?

By default, WORKDAY treats Saturday and Sunday as weekends and does not count them as working days.

intermediate

How can you make WEEKDAY start counting from Monday as 1 instead of Sunday?

Use WEEKDAY(date, 2). This makes Monday = 1, Tuesday = 2, ..., Sunday = 7.

intermediate

How do you exclude holidays in the WORKDAY function?

Add a range or array of holiday dates as the third argument in WORKDAY. These dates will be skipped as non-working days.

What number does WEEKDAY return for Sunday by default?

A 1

B 7

C 0

D Sunday is not counted

By default, WEEKDAY returns 1 for Sunday.

Which function would you use to find the date 10 working days after today?

A TODAY()+10

B WEEKDAY(TODAY()+10)

C WORKDAY(TODAY(), 10)

D WORKDAY(TODAY(), -10)

WORKDAY(TODAY(), 10) returns the date 10 working days after today, skipping weekends.

How do you tell WEEKDAY to count Monday as 1?

A WEEKDAY(date, 1)

B WEEKDAY(date)

C WEEKDAY(date, 3)

D WEEKDAY(date, 2)

Using WEEKDAY(date, 2) makes Monday = 1.

What days does WORKDAY skip by default?

A Friday and Saturday

B Saturday and Sunday

C Sunday only

D No days are skipped by default

WORKDAY skips Saturday and Sunday by default.

How can you make WORKDAY skip holidays?

A Add holidays as the third argument

B Use WEEKDAY with holidays

C WORKDAY automatically skips holidays

D You cannot skip holidays with WORKDAY

You add a list or range of holiday dates as the third argument to WORKDAY to skip them.

Explain how to use the WEEKDAY function to find the day number of a date, and how to change the start day of the week.

Think about the two arguments WEEKDAY takes and what they mean.

Describe how the WORKDAY function calculates dates and how you can exclude weekends and holidays.

Consider how WORKDAY helps with business day calculations.