From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Identifying the day of the week with the WEEKDAY function

Identifying the day of the week with the WEEKDAY function

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Identifying the day of the week with the WEEKDAY function

- Knowing day of the week can be very important with certain kinds of data. You might be analyzing sales data over a multi-year period. Which day of the week is busiest? Is there a trend, has it changed over time? Orders, shipments, which days are busier than others, which days of the week? How do we figure out days of the week? One simple way, probably not the best, is to format date entries a bit differently. So in column A, I'm going to change the format here by either right-clicking, going to Format Cells, or pressing Ctrl+1, either way will take us to the Format Cells dialogue box and on the Number tab, Category Date, we do see lots of options here. This option right here, although quite wide does display day of the week. And there we are, we see day of the week. This is probably not the best way to approach this issue, so let me undo that and use a function here called weekday referring to cell A2, weekday. The answer, may be a bit disappointing at first, is a 2, that means it's…

Contents