Setting Up a Training Schedule

[dwhims]

Hi all!

I am working on a software implementation, and am trying to set up multiple training schedules using Excel. For each schedule, I have an implementation date, which is fixed, and 14 Training Dates to be scheduled. The training dates should be approximately 2 weeks apart, with the final date being about 2 weeks prior to the implementation date.

What I would like to be able to do is plug in the implementation date, and have the 14 Training Dates fill in based on imp. date, and also take into account weekends and holidays. I know there is a WORKDAY formula that would probably help me, but I can't seem to grasp exactly how to use it.

Can anyone help me out???

Thanks a mil!

 

[dwhims]

Wow - I guess it's true what they say about the first step being admitting you have a problem. As soon as I took that step, the solution became clear to me! I even had a moment of clarity while re-reading the Help file for the umpteenth time.

My final formula:
=WORKDAY(E5,-10,$L$4:$L$16)
Where E5 contains my implementation date, L4-L16 contains my list of holidays to be excluded, and -10 is the number of working days between sessions.

Thanks!