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!
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

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!
 

Forum statistics

Threads
1,141,911
Messages
5,709,279
Members
421,625
Latest member
Natalie1107

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top