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
2
Monday, Tuesday
3
Tuesday, Wednesday
4
Wednesday, Thursday
5
Thursday, Friday
6
Friday, Saturday
7
Sunday only
11
Monday only
12
Tuesday only
13
Wednesday only
14
Thursday only
15
Friday only
16
Saturday only
17
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