fill a series of dates excluding holidays
 

I have a spreadsheet that returns a series of appointments based on a
start date.


Name StartDate Lesson 2 Lesson 3 etc.
Name1 26-Jan-05 2-Feb-05 9-Feb-05
Name2 13-Sep-04 20-Sep-04 27-Sep-04

Col A is Name, Col B is start date, etc.
To calculate the remaining dates I add 7 to the start date, then add 7
to each col, copy the formula across for the number of lessons.

I would like to use a function, formula, or VBA solution to do this but
skip over the holidays or other non working times.

Looking for any insight !!
Thanks
GSH20


--
gsh20
------------------------------------------------------------------------
gsh20's Profile: http://www.excelforum.com/member.php...o&userid=26606
View this thread: http://www.excelforum.com/showthread...hreadid=398792

On Wed, 24 Aug 2005 16:43:48 -0500, gsh20
wrote:


I have a spreadsheet that returns a series of appointments based on a
start date.


Name StartDate Lesson 2 Lesson 3 etc.
Name1 26-Jan-05 2-Feb-05 9-Feb-05
Name2 13-Sep-04 20-Sep-04 27-Sep-04

Col A is Name, Col B is start date, etc.
To calculate the remaining dates I add 7 to the start date, then add 7
to each col, copy the formula across for the number of lessons.

I would like to use a function, formula, or VBA solution to do this but
skip over the holidays or other non working times.

Looking for any insight !!
Thanks
GSH20

It depends on what you want to do if the next lesson is scheduled for a
holiday.

If you want to postpone for one day, then:

C1: =workday(B1+6,1,Holidays)
D1: =workday(B1+13,1,Holidays)

If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

How?

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.



--ron