Setting Up a Training Schedule

dwhims

Board Regular
Joined
Sep 10, 2003
Messages
155
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!
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

dwhims

Board Regular
Joined
Sep 10, 2003
Messages
155
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!
 

Watch MrExcel Video

Forum statistics

Threads
1,114,088
Messages
5,545,889
Members
410,711
Latest member
Josh324
Top