Microsoft Office Tutorials and References
In Depth Information
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.
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).
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
Type any date
Guaranteed weekday formula
Guaranteed weekday result
Actual day of the week
WEEKNUM returns a number of where the week falls numerically within a year.
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.
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.