Schedule/Date Calculation

J

JE McGimpsey

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

Gary''s Student

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

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

Ron Rosenfeld

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

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
 
Top