WEEKDAY vs. WORKDAY | CSE 148 – Excel Exam 1

WEEKDAY vs. WORKDAY explained

WEEKDAY

Imagine you've got a dentist appointment on October 15, 2018. You typically work Mondays, Wednesdays, and Fridays, so you'll need to know if you should request off work for this appointment.

Using a calendar, we'd go back to the given date and determine that it's on a Monday, so we'd need to request off work.

The WEEKDAY function does the exact same thing!

Given a date, the WEEKDAY function returns a number between 1-7 representing what day of the week the date is on.

WORKDAY

The WORKDAY function, by contrast, is completely different. It's easy to get them twisted though, so let's visualize the difference.

PAID CONTENT

This is the end of the preview. To unlock the rest, get the Excel Cram Kit (Exam 1) or Lifetime Access.

Already purchased? Click here to log in.

Leave a Comment