I'm trying to schedule classes that have a set amount of class hours. I'd like excel to do the math and populate an end date for me.
If I did the following:
- Enter a start time (6 pm)
- Enter a end time (9pm)
- Enter days per week using excel serial numbes (1 for Monday and 3 for Wed )
- Enter a start date (3/17/14)
- Enter hours
Can excel populate the end date using above values?
I'd like to include a holiday table. If the start and end date ranges fall on a date in the holiday table, 3/26/14, can I get an option to either populate the next available end date in the end date cell or back up the start date (show the what the start will be so I can change it).
The option can be a pop up for yes to populate the next available end date or cancel so I can enter the start date shown (or even change the start date?).
I've included a sample spreadsheet. Thanks!