Want to calculate 3 business days from a certain existing date
 

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

Want to calculate 3 business days from a certain existing date
 

Look in the help index for WORKDAY

--
Don Guillett
SalesAid Software

"lauras03" wrote in message
...
Hi,
I have a invoice and want it to show 3 business days from the invoice
date.
Can excel figure a business day?
--
Thanks,
Laura

Want to calculate 3 business days from a certain existing date
 

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.



"lauras03" wrote:

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