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