The WEEKDAY
function returns the day of the week for
a specific date.
- The syntax
for the function is WEEKDAY (serial_number,
return_type )
.
The "serial_num"
must be a string or a recognizable
date format in Excel. "return_type" represents
the different methods of referencing
the days of the week.
- Type 1 counts from
sunday (1) to saturday (7),
- type 2 counts
from monday (1 to sunday (7)
- and type
3 counts from monday (0) to sunday (6).
Each represents
a different way of the displaying the
answer. For
example:
WEEKDAY ("1/8/2007",2) = 1
and WEEKDAY ("1/8/2007",3)
= 0 but they both represent the same
date and the same day (monday).
|
