magicmusic
New Member
- Joined
- Sep 2, 2011
- Messages
- 8
I teach college music - and need to consistently make and give students a rehearsal plan for a choir which meets 4 of the 5 days (M, W, Th, F) each week. Each plan is usually different lengths of time - sometimes it's a couple weeks, sometimes a whole quarter (10 weeks).
I currently type each date manually for each separate plan - but would like to automate the process.
I would like to be able to generate a set of vertical cells which would contain x amount of days - where x is the amount of class meeting days between date entry 1 and date entry 2.
I would like each cell formatted with mo/day (day first letter),
for example 9/6 (T)
I have been reading the Mr Excel archives for date ideas, and have seen formulas to return #of days in month, 1st Monday of a Month, how many calendar days between dates, etc. I also have been introduced to the workday function - which seems pretty helpful in this case.
I've messed with Macros and VB - though I'm the kind of "programmer" who, left to my own devices, usually needs 10 lines of code where two would do if generated by an expert.
My idea is for a sheet that looks like this:
A2 - begin date
B2 - end date
C2 - amount of class days between A1&B1 (4/week, M, W, Th, F)
A4, A5, A6 . . . (through the number returned in C1)
Thus - the result look something like below:
*********************************
BeginDate | End Date | ClassMeetings
9/15/2011 | 11/4/2011 | 30
9/15 (Th)
9/16 (F)
9/19 (M)
9/21 (W)
|
|
11/4 (F)
**********************************
(no Tuesday meeting)
Again, this list twould be a different length each time, depending upon begin and end date . . .
Thanks in advance for getting me started in the right direction!
Gary
I currently type each date manually for each separate plan - but would like to automate the process.
I would like to be able to generate a set of vertical cells which would contain x amount of days - where x is the amount of class meeting days between date entry 1 and date entry 2.
I would like each cell formatted with mo/day (day first letter),
for example 9/6 (T)
I have been reading the Mr Excel archives for date ideas, and have seen formulas to return #of days in month, 1st Monday of a Month, how many calendar days between dates, etc. I also have been introduced to the workday function - which seems pretty helpful in this case.
I've messed with Macros and VB - though I'm the kind of "programmer" who, left to my own devices, usually needs 10 lines of code where two would do if generated by an expert.
My idea is for a sheet that looks like this:
A2 - begin date
B2 - end date
C2 - amount of class days between A1&B1 (4/week, M, W, Th, F)
A4, A5, A6 . . . (through the number returned in C1)
Thus - the result look something like below:
*********************************
BeginDate | End Date | ClassMeetings
9/15/2011 | 11/4/2011 | 30
9/15 (Th)
9/16 (F)
9/19 (M)
9/21 (W)
|
|
11/4 (F)
**********************************
(no Tuesday meeting)
Again, this list twould be a different length each time, depending upon begin and end date . . .
Thanks in advance for getting me started in the right direction!
Gary
