Schedule/Date Calculation
 

How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend
days??

Take a look at WORKDAYS() in XL Help. This is an Analysis Toolpak Add-in
function (Tools/Add-ins...)

In article ,
lkoyne wrote:

How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend
days??

If the date is in A1, rather than a simple =A1+5

try =A1+5+(WEEKDAY(A1+5)=7)*2+(WEEKDAY(A1+5)=1)
--
Gary's Student


"JE McGimpsey" wrote:

Take a look at WORKDAYS() in XL Help. This is an Analysis Toolpak Add-in
function (Tools/Add-ins...)

In article ,
lkoyne wrote:

How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend
days??

On Tue, 11 Oct 2005 07:40:08 -0700, lkoyne
wrote:

How do I calculate Dates (ie 10/11/05+5) to get only Week Days, not weekend
days??

Look at HELP for the WORKDAY function. It requires installation of the
Analysis Tool Pak.

For your example above:

A1: 10/11/05
B1: 5
C1: =WORKDAY(A1,B1) := Tuesday, October 18, 2005

You'll need to format C1.

Note that the WORKDAY formula has an optional "Holidays" argument where you can
specify a range that contains all of the holidays that you don't want to count.



--ron