Microsoft Office Tutorials and References
In Depth Information
Syntax
The NETWORKDAYS function returns the number of whole workdays between
start_dateand end_date. Workdays exclude weekends and any dates identified
in holidays. You use NETWORKDAYS to calculate employee benefits that
accrue based on the number of days worked during a specific term. This func-
tion takes the following arguments:
start_date
start_date This is a date that represents the start date. Dates may
be entered as text strings within quotation marks (for example, "1/30/
1998", "1998/01/30"), as serial numbers, or as results of other for-
mulas or functions (for example, DATEVALUE("1/30/1998")).
end_date
end_date This is a date that represents the end date.
holidays
holidays This is an optional range of one or more dates to exclude
from the working calendar, such as state and federal holidays and
floating holidays. The list can be either a range of cells that contain
the dates or an array constant of the serial numbers that represent
the dates. If any argument is not a valid date, NETWORKDAYS returns
a #NUM! error.
Both of the functions described in this section assume that Saturday and
Sunday are weekends and are not workdays. If you have any other weekend
system, you can use WORKDAY.INTL or NETWORKDAYS.INTL, as described in
the next section.
In Figure 11.47 , the current date is entered in cell B6. The project due date
is entered in cell B7. The holidays range is in E2:E7, as in the previous
example.
The
formula
in
cell
B8
to
calculate
workdays
is
=NETWORKDAYS(B6,B7,E2:E7).
Search JabSto ::




Custom Search