[paankadu]

Excel 2003

I am trying to set up a macro or formula that will allow me to predict an end
date from a start date. It is 12 hr shift schedule - work 4 nights, 3 off, 3
days, 1 off, 3 nights, 7 off, 4 days, 4 off - (something along that line -
not sure if I have the days in the right order).

Am looking to enter a start date and have it calculate out 30 working days
to find out when to expect testing done. I have not been able to get
anything to work because different start dates show different amounts of days
off. Any ideas on how to go about this.

I have been reading thru the posts on using workday and changing it to
a 6 day schedule but haven't found anything that allows a rotating schedule.
I want to exclude all days off (but include holidays & weekends as they work
those).

Any ideas??? Also, am not very familiar with VBA as of yet ( i have been
able to set up macros using record and stop record, but haven't gotten into
the coding aspect yet) so would also need instructions on how to put it into
a module.

Thanks in advance - your guidance is much appreciated!!!

ex:
column a column b column c column d column e
cert test name start date min days max days completion date

shift sched is currently in table format but doesn't reflect mm/dd/yy -
would create new table that reflects date and whether they work days or
nights or not at all

1/1/08 d
1/2/08 d
1/3/08 d
1/4/08 x
1/5/08 x
1/6/08 x
1/7/08 n
etc.....

any ideas on how to get it to calculate correctly..

Thanks in advance!!

--
Thanks,
Angie