Microsoft Office Tutorials and References

In Depth Information

**Determining the Day of the Week**

Here is how you use the WEEKDAY function:

1. Select the cell where you want the results displayed.

2. Enter
=WEEKDAY(
to begin the function entry.

3. Select the cell that has the date you want to find out the weekday for.

4. Type a
), and press Enter.

WEEKDAY returns a number between 1 and 7. Table 12-1 shows what the

returned number means.

Table 12-1

WEEKDAY Returned Values

Returned Value

Weekday

1

Sunday

2

Monday

3

Tuesday

4

Wednesday

5

Thursday

6

Friday

7

Saturday

Don’t confuse the returned numbers with actual dates! Just because Table

12-1 shows a value of 4 indicating Wednesday doesn’t mean the fourth of a

month is a Wednesday. The values of the returned numbers are also a bit

confusing because most people consider Monday, not Sunday, to be the first

day of the week. You can go argue the point with Microsoft if you like! Or,

better yet, you can include a second, optional, argument that tells WEEKDAY

to return 1 for Monday, 2 for Tuesday, and so on:

=WEEKDAY(A1, 2)

The numbers 1 through 7, returned from the WEEKDAY function, are not the

same as the first through seventh of the month.

The WEEKDAY function lets you extract interesting information from

daterelated data. For example, maybe you’re on a diet and you’re keeping a tally

of how many calories you consume each day for a month. Then you start

wondering, “Am I eating more on weekends than on weekdays?” Figure 12-8

shows a worksheet that calculates the average calories consumed on each

day of the week over a month’s time. A quick glance at the results shows that