Microsoft Office Tutorials and References
In Depth Information
Working with Workdays
5. Click the cell that has the number end date for the range of dates to
be counted.
If you want to add a list of dates to exclude, continue to Steps 6 and 7;
otherwise, skip these and go to Step 8.
6. Enter a comma ( ,).
7.Clickanddragthepointeroverthecellsthathavethedatestoexclude.
8. Type a ), and press Enter.
The result is a count of days, between the start and end dates, that
do not fall on Saturday or Sunday and are not in an optional list of
exclusion dates.
Workdays in the future
Sometimes you are given a deadline — or you may give it to someone else:
“Have that back to me in 20 working days.” Fine, but what is the date 20
working days from now? The WORKDAY function comes to the rescue. You
specify a start date, the number of working days, and an optional list of holidays
that are not to be counted as working days. (This list works just the same as
for the NETWORKDAYS function discussed in the previous section.)
To use WORKDAYS, follow these steps:
1. Select the cell where you want the results displayed.
2. Enter =WORKDAY( to begin the function entry.
3. Click the cell that has the start date for the calculation.
4. Enter a comma ( ,).
5. Click the cell that has the number of workdays, or enter the number
directly in the formula.
If you want to add a list of dates to exclude in the count, continue to
Steps 6 and 7; otherwise, skip these and go to Step 8.
6. Enter a comma ( ,).
7. Click and drag the pointer over the cells that have the dates to be
excluded.
8. Type a ), and press Enter.
The result is a date that is the specified number of workdays from the
start date, not counting dates in the optional list of exclusion dates.
Search JabSto ::




Custom Search