Excel 2000 in a Nutshell

Name

WEEKDAY

Synopsis

Use this function to determine the day of the week that a specific date falls on. Excel returns an integer value between 0 and 7 that represents the day of the week.

To Calculate

=WEEKDAY(Serial_Number, Return_Type)

Although you must specify a date, the Return_Type argument is optional.

Return_Type

This argument indicates what day you choose as the first day of the week. The value of this argument can be an integer value between 1 and 3, as described in the following list. For example, if you select Sunday as the first day of the week, use 1 as the value. If you do not provide a value for the Return_Type argument, the default value is 1.

1

This is the default value for the Return_Type argument. If you specify this value, Sunday is considered the first day and has a value of 1, with Saturday the last day of the week with a value of 7. Therefore, if the date is a Wednesday, Excel returns a value of 4.

2

If you specify this value Monday is considered the first day of the week and has a value of 1, with Sunday having a value of 7.

3

If you specify this value Monday is considered the first day of the week, but it is numbered differently than the other methods. The numbering starts at 0 for Monday, with the last day (Sunday) having a value of 6.

Example

Figure 13-12 illustrates how WEEKDAY is used to determine the day of the week. When combined with TEXT you are able to convert the integer returned by WEEKDAY to a text value. For more information about using the TEXT ...