Help!

Want to calculate 3 business days from a certain existing ..

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions RSS
Next:  How do I create a tracking log  
Author Message
lauras03
External


Since: Feb 16, 2007
Posts: 10



PostPosted: Sun Mar 11, 2007 9:14 pm    Post subject: Want to calculate 3 business days from a certain existing date
Archived from groups: microsoft>public>excel>misc (more info?)

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
Back to top
Vergel Adriano
External


Since: Feb 21, 2007
Posts: 130



PostPosted: Sun Mar 11, 2007 9:24 pm    Post subject: RE: Want to calculate 3 business days from a certain existing date [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
Back to top
Don Guillett
External


Since: Jan 04, 2006
Posts: 3013



PostPosted: Sun Mar 11, 2007 11:22 pm    Post subject: Re: Want to calculate 3 business days from a certain existing date [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Look in the help index for WORKDAY

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"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
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> General Discussions All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum