WEEKDAY and WORKDAY in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the WEEKDAY function do in Excel?

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 Excel?

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

intermediate

What is the difference between WEEKDAY and WORKDAY functions?

WEEKDAY tells you the day number of a specific date, while WORKDAY gives you a future or past date after adding or subtracting working days.

intermediate

How can you exclude holidays in the WORKDAY function?

You can provide a list or range of holiday dates as the third argument in WORKDAY, so those days are not counted as working days.

beginner

What does WEEKDAY(date, 2) return for a Monday?

It returns 1 because with return type 2, the week starts on Monday as 1 and Sunday is 7.

What number does WEEKDAY return for Sunday if you use WEEKDAY(date, 1)?

A 1

B 7

C 0

D Sunday is not returned as a number

With return type 1, Sunday is 1, Monday is 2, and so on.

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

A TODAY

B WEEKDAY

C WORKDAY

D NETWORKDAYS

WORKDAY calculates a date after adding working days, skipping weekends and holidays.

How do you tell WORKDAY to skip holidays?

A Use WEEKDAY with holidays

B WORKDAY cannot skip holidays

C Set holidays in Excel options

D Add holidays as the third argument

WORKDAY accepts a range or list of holiday dates as the third argument to exclude them.

If WEEKDAY returns 5 for a date with return type 2, what day is it?

A Friday

B Monday

C Thursday

D Sunday

Return type 2 means Monday=1, so 5 is Friday.

What does WORKDAY(start_date, -3) do?

A Gives the date 3 working days after start_date

B Gives the date 3 working days before start_date

C Gives the date 3 calendar days before start_date

D Gives the weekday number of start_date

Negative numbers in WORKDAY count backward working days.

Explain how to use the WEEKDAY function to find the day of the week for a date and how the return type affects the result.

Think about how Sunday or Monday can be numbered differently.

Describe how the WORKDAY function helps in planning by skipping weekends and holidays, including how to add holidays.

Consider a work project deadline calculation.