Microsoft Office Tutorials and References
In Depth Information
Working with specialized date functions
of workdays before or after the start date, excluding weekends and holidays. Use a positive
value for days to count forward from the start date; use a negative value to count
backward. The optional holidays argument can be an array or a reference to a cell range that
contains any dates you want to exclude from the calculation. If you leave holidays blank,
the function counts all weekdays from the start date. For example, to determine the date
that is 100 working days, not counting holidays, from the current date, type the formula
=WORKDAY(NOW( ),100) .
Similarly, the NETWORKDAYS function calculates the number of working days between
two given dates. It takes the arguments ( start_date , end_date , holidays ). For example, to
determine the number of working days from January 15, 2014 to June 30, 2014, type the
formula =NETWORKDAYS("1/15/14", "6/30/14") , which results in a value of 119 .
The WORKDAY.INTL and NETWORKDAYS.INTL functions work the same way as their
nonINTL counterparts, but each includes an additional weekend argument. These functions use
the form ( start_date , days , weekend, holidays ), where weekend is a number indicating which
days you want to omit, as shown in Table 15-4.
TABLE 15-4 INTL weekend codes
If weekend is The weekend days omitted are
1 or omitted
Saturday, Sunday
Sunday, Monday
Monday, Tuesday
Tuesday, Wednesday
Wednesday, Thursday
Thursday, Friday
Friday, Saturday
Sunday only
Monday only
Tuesday only
Wednesday only
Thursday only
Friday only
Saturday only
There are two ways to specify the weekend argument. The first is to enter one of the
numbers shown in Table 15-4, which are codes that specify days you want to omit. The other
method is to enter a 7-digit numeric text string with which you specify individual days of
the week (starting with Monday) that you want to include and exclude; a zero (0) indicates
Search JabSto ::

Custom Search