Microsoft Office Tutorials and References
In Depth Information
WORKDAY
WORKDAY
WORKDAY returns a date that is indicated by the number of working days including holidays.
=WORKDAY(serial_number,return_type)
The WORKDAY 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. Notice in the example in Figure 4.11, the start date is indicated in cell B12;
11/15/2000 and the number of workdays for the project is 100, if you have 5 holidays in the
range D12:D16, what’s the final date the project will complete on? The result is the date value
of 4/6/2001. The WORKDAY function is good for scheduling events and invoices.
The start date.
START DATE
The number of non-weekend and non-holiday workdays available
before or after the start date.
DAYS
One or more dates that will be included in the formula but excluded
in the days available.
HOLIDAYS
Figure 4.11
The WORKDAY function
is good for scheduling
dates in the future
when a start date is
known as well as the
number of workdays.
A
Project start date
B
Workdays
available for
a project
C
Completion date after
considering holidays
YEA YEAR returns the corresponding year as a serial number in the form of an integer.
=YEAR(serial_number)
The YEAR function returns the date time code between the numbers 1900 and 9999. The serial
number is the code that Excel uses for date and time calculations. The date and value of
Windows date systems is any date from 1/1/1900 to 12/31/9999. The date value of Macintosh
systems is any date from 1/1/1904 to 12/31/9999. In the O ptions dialog box from the Tools
Search JabSto ::




Custom Search