G
gsh20
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
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