Microsoft Excel Functions & Formulas

Use the WORKDAY function to calculate

workdays

A worksheet is used to schedule a project. The project contains the

start date and five major steps. Each step takes an estimated num-

ber of days to accomplish. To determine the correct end date,

weekends and additional days off have to be taken into consider-

ation. To perform this task, use the WORKDAY function from the

Analysis ToolPak add-in. This function returns a date that is the

indicated number of workdays before or after a date. Workdays

exclude weekends and any dates identified as holidays. The syntax

is as follows:

WORKDAY(start_date, days, holidays)

start_date: The start date.

days: The total number ...