Chapter 12: Using Formulas with Dates and Times
12
One of the easiest ways to generate a list of business days is to use the WORKDAY.INTL
function. Start with a spreadsheet that contains the last date of the previous year and
a list of your organization’s holidays. As you can see in Figure 12.4, your list of holidays
should be formatted dates.
FIGURE 12.4
Start with a sheet containing the last date of the previous year and a list of holidays.
In the cell beneath the last date of the previous year, enter this formula:
=WORKDAY.INTL(B3,1,1,$D$4:$D$15)At this point, you can copy the formula down to create as many business days as you need
(see Figure 12.5).
FIGURE 12.5
Creating a list of business days