| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you count work days excluding weekends and holidays? | Excel Discussion (Misc queries) | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
| fill series | Excel Discussion (Misc queries) | |||
| fill series grayed out (not available, disactivated) | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Threaded Mode
