Want to calculate 3 business days from a certain existing date

L

lauras03

Hi,
I have a invoice and want it to show 3 business days from the invoice date.
Can excel figure a business day?
 
V

Vergel Adriano

Laura,

Make sure you have the Analysis Toolpack add-in enabled. Tools->Add-Ins,
make sure "Analysis ToolPack" is checked. Then, search the help for the
WORKDAY() function. Syntax is

=WORKDAY(start_date, days, holidays)

days is the number of noonweekend and nonholiday days before or after
start_date.

holidays is an optional list of dates to exclue from the working calendar.
 
Top