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