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.
WEEKDAY Returned Values
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:
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