Class Schedule Generator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRS
1
This spreadsheet generates a list of dates and days for typical class schedules at Gustavus. To use the spreadsheet, choose the schedule (e.g., MWF or TTh) that your class follows and enter the date of your first class period in the green cell of the appropriate section (if it hasn't already been updated for the current semester). The cells below and to the right of the green cell will automatically update themselves. You can then highlight the dates & days and copy and paste them into the software that you are using to maintain your class schedule. Next semester, return to this spreadsheet and change the date in the green cell to generate a new schedule. Hope this saves you some time.

Notes: The formulas used to generate the dates assume that if you are in the MWF section, the first date you enter is either a M, W, or F, and if you are in the TTh section, the first date is either a T or Th. If these assumptions aren't satisfied, the dates won't update properly. The spreadsheet generates more dates than you need (especially for classes that meet only twice a week). After you copy them from this spreadsheet, just delete the dates you don't need.
2
MWF ClassesTTh ClassesMW Classes
3
DateDay of WeekDate Day of WeekDateDay of Week
4
9/5/2018Wednesday9/4/2018Tuesday9/5/2018Wednesday
5
9/7/2018Friday9/6/2018Thursday9/10/2018Monday
6
9/10/2018Monday9/11/2018Tuesday9/12/2018Wednesday
7
9/12/2018Wednesday9/13/2018Thursday9/17/2018Monday
8
9/14/2018Friday9/18/2018Tuesday9/19/2018Wednesday
9
9/17/2018Monday9/20/2018Thursday9/24/2018Monday
10
9/19/2018Wednesday9/25/2018Tuesday9/26/2018Wednesday
11
9/21/2018Friday9/27/2018Thursday10/1/2018Monday
12
9/24/2018Monday10/2/2018Tuesday10/3/2018Wednesday
13
9/26/2018Wednesday10/4/2018Thursday10/8/2018Monday
14
9/28/2018Friday10/9/2018Tuesday10/10/2018Wednesday
15
10/1/2018Monday10/11/2018Thursday10/15/2018Monday
16
10/3/2018Wednesday10/16/2018Tuesday10/17/2018Wednesday
17
10/5/2018Friday10/18/2018Thursday10/22/2018Monday
18
10/8/2018Monday10/23/2018Tuesday10/24/2018Wednesday
19
10/10/2018Wednesday10/25/2018Thursday10/29/2018Monday
20
10/12/2018Friday10/30/2018Tuesday10/31/2018Wednesday
21
10/15/2018Monday11/1/2018Thursday11/5/2018Monday
22
10/17/2018Wednesday11/6/2018Tuesday11/7/2018Wednesday
23
10/19/2018Friday11/8/2018Thursday11/12/2018Monday
24
10/22/2018Monday11/13/2018Tuesday11/14/2018Wednesday
25
10/24/2018Wednesday11/15/2018Thursday11/19/2018Monday
26
10/26/2018Friday11/20/2018Tuesday11/21/2018Wednesday
27
10/29/2018Monday11/22/2018Thursday11/26/2018Monday
28
10/31/2018Wednesday11/27/2018Tuesday11/28/2018Wednesday
29
11/2/2018Friday11/29/2018Thursday12/3/2018Monday
30
11/5/2018Monday12/4/2018Tuesday12/5/2018Wednesday
31
11/7/2018Wednesday12/6/2018Thursday12/10/2018Monday
32
11/9/2018Friday12/11/2018Tuesday12/12/2018Wednesday
33
11/12/2018Monday12/13/2018Thursday12/17/2018Monday
34
11/14/2018Wednesday12/18/2018Tuesday12/19/2018Wednesday
35
11/16/2018Friday12/20/2018Thursday12/24/2018Monday
36
11/19/2018Monday12/25/2018Tuesday12/26/2018Wednesday
37
11/21/2018Wednesday12/27/2018Thursday12/31/2018Monday
38
11/23/2018Friday1/1/2019Tuesday1/2/2019Wednesday
39
11/26/2018Monday1/3/2019Thursday1/7/2019Monday
40
11/28/2018Wednesday1/8/2019Tuesday1/9/2019Wednesday
41
11/30/2018Friday1/10/2019Thursday1/14/2019Monday
42
12/3/2018Monday1/15/2019Tuesday1/16/2019Wednesday
43
12/5/2018Wednesday1/17/2019Thursday1/21/2019Monday
44
12/7/2018Friday1/22/2019Tuesday1/23/2019Wednesday
45
12/10/2018Monday1/24/2019Thursday1/28/2019Monday
46
12/12/2018Wednesday1/29/2019Tuesday1/30/2019Wednesday
47
12/14/2018Friday1/31/2019Thursday2/4/2019Monday
48
12/17/2018Monday2/5/2019Tuesday2/6/2019Wednesday
49
12/19/2018Wednesday2/7/2019Thursday2/11/2019Monday
50
12/21/2018Friday2/12/2019Tuesday2/13/2019Wednesday
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu