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