Microsoft Office Tutorials and References
In Depth Information
WEEKNUM
The serial number is the date time code used by Microsoft
Excel. You can specify the serial number as text and Excel will
automatically convert the serial number text to the day value,
or you can apply the day value.
SERIAL NUMBER
This number determines the type of return value. 1 or
omitted, returns 1 (Sun) through 7 (Sat) or 2 returns 1 (Mon)
through 7 (Sun) or 3 returns 0 (Mon) through 6 (Sun).
RETURN TYPE
Figure 4.10
The WEEKDAY function
allows you to determine
a date’s day of the
week with a result
between 1 and 7 with
the first day equal to
Sunday.
C
Type any date
here.
D
Guaranteed weekday formula
A
Guaranteed weekday result
B
Actual day of the week
WEEKNUM
WEEKNUM returns a number of where the week falls numerically within a year.
=WEEKNUM(serial_number,return_type)
The WEEKNUM function is found in the Analysis Toolpak. If you don’t see the WEEKNUM function,
you must first install the Analysis Toolpak and then enable the Toolpak under Add-Ins from
the Tools menu. In this instance, the formula =WEEKNUM(“12/25/00”,1) returns the week
number 52, and the formula =WEEKNUM(“1/1/00”,1) returns the week number 1.
The serial number date within the week.
SERIAL NUMBER
This number determines the type of return value. 1 begins the
week on Sunday and 2 begins the week on Monday. The
weekdays are numbered 1 through 7.
RETURN TYPE
Search JabSto ::




Custom Search