Schedule/Date Calculation

[Guest]

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

 

[JE McGimpsey]

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

 

[Guest]

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

try =A1+5+(WEEKDAY(A1+5)=7)*2+(WEEKDAY(A1+5)=1)

 

[Ron Rosenfeld]

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