Friday the 13th
Study
The following project list items that can be discussed as a part of examining the pattern of occurrence of Friday the 13th. This particular project starts with an examination of the following:
1. Show that for any year, there must be at least one month and at most 3 months for which the 13th of the month falls on a Friday.
2. Observe that in 1998, both February and March have a Friday the 13th.
Questions that arise from this:
1. Prove that Friday the 13th can only occur in consecutive months, when these two months are February and March.
2. On what day of the week must January 1 occur for February and March to have Friday the 13ths?
3. What is the next year that this will occur?
4. Is there a pattern or cycle by which you can determine which years between 2000 and 2100 that this will occur?
A review of the methods used to provide answers to these questions is provided below. This is divided into two areas:
Consecutive Months with Friday the 13th Deals with the first 2 questions.
Patterns and Cycles Shows the patterns associated the questions 3 and 4.
RETURN TO
Carl’s EMAT 6690 Page
An Excel Spreadsheet technique can be used to show that there must be at least on month each year where the 13th of the month falls on a Friday, as well as showing that as many as three months may have the 13th fall on a Friday. Construction of the spreadsheet is setup by establishing 2 different worksheets, one for the case where the year is a leap year (366 day year) and the other then there is no leap year (365 day year). Construction follows the following steps:
This can be accomplished by entering the date January 1st in the first cell of the column, then (by selecting the lower right corner of the cell and dragging down the column) input ever increasing dates up to and including December 31st.
Start with entering a 0 in the column next to the date column. Continue entering increasing values (1 ... 364) for the remainder of the dates.
This is accomplished by entering the formula:
MOD(rC,7)+1
Where r refers to the row and C the column for the day number to be converted.
When this first step is completed, you should have a spreadsheet that looks like the following:
Calendar for Years with
365 days |
||
|
|
|
Start on Sunday |
||
1-Jan |
0 |
1 |
2-Jan |
1 |
2 |
3-Jan |
2 |
3 |
4-Jan |
3 |
4 |
5-Jan |
4 |
5 |
6-Jan |
5 |
6 |
7-Jan |
6 |
7 |
8-Jan |
7 |
1 |
9-Jan |
8 |
2 |
10-Jan |
9 |
3 |
11-Jan |
10 |
4 |
12-Jan |
11 |
5 |
13-Jan |
12 |
6 |
14-Jan |
13 |
7 |
15-Jan |
14 |
1 |
16-Jan |
15 |
2 |
17-Jan |
16 |
3 |
18-Jan |
17 |
4 |
19-Jan |
18 |
5 |
20-Jan |
19 |
6 |
21-Jan |
20 |
7 |
22-Jan |
21 |
1 |
23-Jan |
22 |
2 |
24-Jan |
23 |
3 |
25-Jan |
24 |
4 |
26-Jan |
25 |
5 |
27-Jan |
26 |
6 |
28-Jan |
27 |
7 |
29-Jan |
28 |
1 |
30-Jan |
29 |
2 |
31-Jan |
30 |
3 |
.
.
.
1-Dec |
334 |
6 |
2-Dec |
335 |
7 |
3-Dec |
336 |
1 |
4-Dec |
337 |
2 |
5-Dec |
338 |
3 |
6-Dec |
339 |
4 |
7-Dec |
340 |
5 |
8-Dec |
341 |
6 |
9-Dec |
342 |
7 |
10-Dec |
343 |
1 |
11-Dec |
344 |
2 |
12-Dec |
345 |
3 |
13-Dec |
346 |
4 |
14-Dec |
347 |
5 |
15-Dec |
348 |
6 |
16-Dec |
349 |
6 |
17-Dec |
350 |
0 |
18-Dec |
351 |
1 |
19-Dec |
352 |
2 |
20-Dec |
353 |
3 |
21-Dec |
354 |
4 |
22-Dec |
355 |
5 |
23-Dec |
356 |
6 |
24-Dec |
357 |
0 |
25-Dec |
358 |
1 |
26-Dec |
359 |
2 |
27-Dec |
360 |
3 |
28-Dec |
361 |
4 |
29-Dec |
362 |
5 |
30-Dec |
363 |
6 |
31-Dec |
364 |
0 |
This will be the equivalent of starting January 1 on a Sunday.
(EXCEL Users) Link to the Spreadsheet
When this step is completed, you should have a spreadsheet that looks like the following:
Calendar for Years with 365 days |
|
|
|
||
|
|
|
|
|
|
Start on Sunday |
|
|
|
||
1-Jan |
0 |
1 |
Start on Monday |
||
2-Jan |
1 |
2 |
1-Jan |
1 |
2 |
3-Jan |
2 |
3 |
2-Jan |
2 |
3 |
4-Jan |
3 |
4 |
3-Jan |
3 |
4 |
5-Jan |
4 |
5 |
4-Jan |
4 |
5 |
6-Jan |
5 |
6 |
5-Jan |
5 |
6 |
7-Jan |
6 |
7 |
6-Jan |
6 |
7 |
8-Jan |
7 |
1 |
7-Jan |
7 |
1 |
9-Jan |
8 |
2 |
8-Jan |
8 |
2 |
10-Jan |
9 |
3 |
9-Jan |
9 |
3 |
11-Jan |
10 |
4 |
10-Jan |
10 |
4 |
12-Jan |
11 |
5 |
11-Jan |
11 |
5 |
13-Jan |
12 |
6 |
12-Jan |
12 |
6 |
14-Jan |
13 |
7 |
13-Jan |
13 |
7 |
15-Jan |
14 |
1 |
14-Jan |
14 |
1 |
16-Jan |
15 |
2 |
15-Jan |
15 |
2 |
17-Jan |
16 |
3 |
16-Jan |
16 |
3 |
18-Jan |
17 |
4 |
17-Jan |
17 |
4 |
19-Jan |
18 |
5 |
18-Jan |
18 |
5 |
20-Jan |
19 |
6 |
19-Jan |
19 |
6 |
21-Jan |
20 |
7 |
20-Jan |
20 |
7 |
22-Jan |
21 |
1 |
21-Jan |
21 |
1 |
23-Jan |
22 |
2 |
22-Jan |
22 |
2 |
24-Jan |
23 |
3 |
23-Jan |
23 |
3 |
25-Jan |
24 |
4 |
24-Jan |
24 |
4 |
26-Jan |
25 |
5 |
25-Jan |
25 |
5 |
27-Jan |
26 |
6 |
26-Jan |
26 |
6 |
28-Jan |
27 |
7 |
27-Jan |
27 |
7 |
29-Jan |
28 |
1 |
28-Jan |
28 |
1 |
30-Jan |
29 |
2 |
29-Jan |
29 |
2 |
31-Jan |
30 |
3 |
30-Jan |
30 |
3 |
.
.
.
1-Dec |
334 |
6 |
30-Nov |
334 |
6 |
2-Dec |
335 |
7 |
1-Dec |
335 |
7 |
3-Dec |
336 |
1 |
2-Dec |
336 |
1 |
4-Dec |
337 |
2 |
3-Dec |
337 |
2 |
5-Dec |
338 |
3 |
4-Dec |
338 |
3 |
6-Dec |
339 |
4 |
5-Dec |
339 |
4 |
7-Dec |
340 |
5 |
6-Dec |
340 |
5 |
8-Dec |
341 |
6 |
7-Dec |
341 |
6 |
9-Dec |
342 |
7 |
8-Dec |
342 |
7 |
10-Dec |
343 |
1 |
9-Dec |
343 |
1 |
11-Dec |
344 |
2 |
10-Dec |
344 |
2 |
12-Dec |
345 |
3 |
11-Dec |
345 |
3 |
13-Dec |
346 |
4 |
12-Dec |
346 |
4 |
14-Dec |
347 |
5 |
13-Dec |
347 |
5 |
15-Dec |
348 |
6 |
14-Dec |
348 |
6 |
16-Dec |
349 |
6 |
15-Dec |
349 |
6 |
17-Dec |
350 |
0 |
16-Dec |
350 |
0 |
18-Dec |
351 |
1 |
17-Dec |
351 |
1 |
19-Dec |
352 |
2 |
18-Dec |
352 |
2 |
20-Dec |
353 |
3 |
19-Dec |
353 |
3 |
21-Dec |
354 |
4 |
20-Dec |
354 |
4 |
22-Dec |
355 |
5 |
21-Dec |
355 |
5 |
23-Dec |
356 |
6 |
22-Dec |
356 |
6 |
24-Dec |
357 |
0 |
23-Dec |
357 |
0 |
25-Dec |
358 |
1 |
24-Dec |
358 |
1 |
26-Dec |
359 |
2 |
25-Dec |
359 |
2 |
27-Dec |
360 |
3 |
26-Dec |
360 |
3 |
28-Dec |
361 |
4 |
27-Dec |
361 |
4 |
29-Dec |
362 |
5 |
28-Dec |
362 |
5 |
30-Dec |
363 |
6 |
29-Dec |
363 |
6 |
31-Dec |
364 |
0 |
30-Dec |
364 |
0 |
|
365 |
|
31-Dec |
365 |
1 |
(EXCEL Users) Link to the Spreadsheet
Continue copying the 3 columns additional rows down for the year starting on Tuesday through Saturday. Be sure to change the starting number for the 2nd column of the groups from 1 (Monday start) to 2 (for Tuesday), 3 (for Wednesday) etc.
When this step is completed, you should have a spreadsheet that looks like the following:
Calendar for Years with 365 days |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Start on Sunday |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||
1-Jan |
0 |
1 |
Start on Monday |
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
|
0 |
|
||
2-Jan |
1 |
2 |
1-Jan |
1 |
2 |
Start on Tuesday |
|
1 |
|
|
1 |
|
|
1 |
|
|
1 |
|
||
3-Jan |
2 |
3 |
2-Jan |
2 |
3 |
1-Jan |
2 |
3 |
Start on Wednesday |
|
2 |
|
|
2 |
|
|
2 |
|
||
4-Jan |
3 |
4 |
3-Jan |
3 |
4 |
2-Jan |
3 |
4 |
1-Jan |
3 |
4 |
Start on Thursday |
|
3 |
|
|
3 |
|
||
5-Jan |
4 |
5 |
4-Jan |
4 |
5 |
3-Jan |
4 |
5 |
2-Jan |
4 |
5 |
1-Jan |
4 |
5 |
Start on Friday |
|
4 |
|
||
6-Jan |
5 |
6 |
5-Jan |
5 |
6 |
4-Jan |
5 |
6 |
3-Jan |
5 |
6 |
2-Jan |
5 |
6 |
1-Jan |
5 |
6 |
Start on Saturday |
||
7-Jan |
6 |
7 |
6-Jan |
6 |
7 |
5-Jan |
6 |
7 |
4-Jan |
6 |
7 |
3-Jan |
6 |
7 |
2-Jan |
6 |
7 |
1-Jan |
6 |
7 |
8-Jan |
7 |
1 |
7-Jan |
7 |
1 |
6-Jan |
7 |
1 |
5-Jan |
7 |
1 |
4-Jan |
7 |
1 |
3-Jan |
7 |
1 |
2-Jan |
7 |
1 |
9-Jan |
8 |
2 |
8-Jan |
8 |
2 |
7-Jan |
8 |
2 |
6-Jan |
8 |
2 |
5-Jan |
8 |
2 |
4-Jan |
8 |
2 |
3-Jan |
8 |
2 |
10-Jan |
9 |
3 |
9-Jan |
9 |
3 |
8-Jan |
9 |
3 |
7-Jan |
9 |
3 |
6-Jan |
9 |
3 |
5-Jan |
9 |
3 |
4-Jan |
9 |
3 |
11-Jan |
10 |
4 |
10-Jan |
10 |
4 |
9-Jan |
10 |
4 |
8-Jan |
10 |
4 |
7-Jan |
10 |
4 |
6-Jan |
10 |
4 |
5-Jan |
10 |
4 |
12-Jan |
11 |
5 |
11-Jan |
11 |
5 |
10-Jan |
11 |
5 |
9-Jan |
11 |
5 |
8-Jan |
11 |
5 |
7-Jan |
11 |
5 |
6-Jan |
11 |
5 |
13-Jan |
12 |
6 |
12-Jan |
12 |
6 |
11-Jan |
12 |
6 |
10-Jan |
12 |
6 |
9-Jan |
12 |
6 |
8-Jan |
12 |
6 |
7-Jan |
12 |
6 |
14-Jan |
13 |
7 |
13-Jan |
13 |
7 |
12-Jan |
13 |
7 |
11-Jan |
13 |
7 |
10-Jan |
13 |
7 |
9-Jan |
13 |
7 |
8-Jan |
13 |
7 |
15-Jan |
14 |
1 |
14-Jan |
14 |
1 |
13-Jan |
14 |
1 |
12-Jan |
14 |
1 |
11-Jan |
14 |
1 |
10-Jan |
14 |
1 |
9-Jan |
14 |
1 |
16-Jan |
15 |
2 |
15-Jan |
15 |
2 |
14-Jan |
15 |
2 |
13-Jan |
15 |
2 |
12-Jan |
15 |
2 |
11-Jan |
15 |
2 |
10-Jan |
15 |
2 |
17-Jan |
16 |
3 |
16-Jan |
16 |
3 |
15-Jan |
16 |
3 |
14-Jan |
16 |
3 |
13-Jan |
16 |
3 |
12-Jan |
16 |
3 |
11-Jan |
16 |
3 |
18-Jan |
17 |
4 |
17-Jan |
17 |
4 |
16-Jan |
17 |
4 |
15-Jan |
17 |
4 |
14-Jan |
17 |
4 |
13-Jan |
17 |
4 |
12-Jan |
17 |
4 |
19-Jan |
18 |
5 |
18-Jan |
18 |
5 |
17-Jan |
18 |
5 |
16-Jan |
18 |
5 |
15-Jan |
18 |
5 |
14-Jan |
18 |
5 |
13-Jan |
18 |
5 |
20-Jan |
19 |
6 |
19-Jan |
19 |
6 |
18-Jan |
19 |
6 |
17-Jan |
19 |
6 |
16-Jan |
19 |
6 |
15-Jan |
19 |
6 |
14-Jan |
19 |
6 |
21-Jan |
20 |
7 |
20-Jan |
20 |
7 |
19-Jan |
20 |
7 |
18-Jan |
20 |
7 |
17-Jan |
20 |
7 |
16-Jan |
20 |
7 |
15-Jan |
20 |
7 |
22-Jan |
21 |
1 |
21-Jan |
21 |
1 |
20-Jan |
21 |
1 |
19-Jan |
21 |
1 |
18-Jan |
21 |
1 |
17-Jan |
21 |
1 |
16-Jan |
21 |
1 |
23-Jan |
22 |
2 |
22-Jan |
22 |
2 |
21-Jan |
22 |
2 |
20-Jan |
22 |
2 |
19-Jan |
22 |
2 |
18-Jan |
22 |
2 |
17-Jan |
22 |
2 |
24-Jan |
23 |
3 |
23-Jan |
23 |
3 |
22-Jan |
23 |
3 |
21-Jan |
23 |
3 |
20-Jan |
23 |
3 |
19-Jan |
23 |
3 |
18-Jan |
23 |
3 |
25-Jan |
24 |
4 |
24-Jan |
24 |
4 |
23-Jan |
24 |
4 |
22-Jan |
24 |
4 |
21-Jan |
24 |
4 |
20-Jan |
24 |
4 |
19-Jan |
24 |
4 |
26-Jan |
25 |
5 |
25-Jan |
25 |
5 |
24-Jan |
25 |
5 |
23-Jan |
25 |
5 |
22-Jan |
25 |
5 |
21-Jan |
25 |
5 |
20-Jan |
25 |
5 |
27-Jan |
26 |
6 |
26-Jan |
26 |
6 |
25-Jan |
26 |
6 |
24-Jan |
26 |
6 |
23-Jan |
26 |
6 |
22-Jan |
26 |
6 |
21-Jan |
26 |
6 |
28-Jan |
27 |
7 |
27-Jan |
27 |
7 |
26-Jan |
27 |
7 |
25-Jan |
27 |
7 |
24-Jan |
27 |
7 |
23-Jan |
27 |
7 |
22-Jan |
27 |
7 |
29-Jan |
28 |
1 |
28-Jan |
28 |
1 |
27-Jan |
28 |
1 |
26-Jan |
28 |
1 |
25-Jan |
28 |
1 |
24-Jan |
28 |
1 |
23-Jan |
28 |
1 |
30-Jan |
29 |
2 |
29-Jan |
29 |
2 |
28-Jan |
29 |
2 |
27-Jan |
29 |
2 |
26-Jan |
29 |
2 |
25-Jan |
29 |
2 |
24-Jan |
29 |
2 |
31-Jan |
30 |
3 |
30-Jan |
30 |
3 |
29-Jan |
30 |
3 |
28-Jan |
30 |
3 |
27-Jan |
30 |
3 |
26-Jan |
30 |
3 |
25-Jan |
30 |
3 |
.
.
.
1-Dec |
334 |
6 |
30-Nov |
334 |
6 |
29-Nov |
334 |
6 |
28-Nov |
334 |
6 |
27-Nov |
334 |
6 |
26-Nov |
334 |
6 |
25-Nov |
334 |
6 |
2-Dec |
335 |
7 |
1-Dec |
335 |
7 |
30-Nov |
335 |
7 |
29-Nov |
335 |
7 |
28-Nov |
335 |
7 |
27-Nov |
335 |
7 |
26-Nov |
335 |
7 |
3-Dec |
336 |
1 |
2-Dec |
336 |
1 |
1-Dec |
336 |
1 |
30-Nov |
336 |
1 |
29-Nov |
336 |
1 |
28-Nov |
336 |
1 |
27-Nov |
336 |
1 |
4-Dec |
337 |
2 |
3-Dec |
337 |
2 |
2-Dec |
337 |
2 |
1-Dec |
337 |
2 |
30-Nov |
337 |
2 |
29-Nov |
337 |
2 |
28-Nov |
337 |
2 |
5-Dec |
338 |
3 |
4-Dec |
338 |
3 |
3-Dec |
338 |
3 |
2-Dec |
338 |
3 |
1-Dec |
338 |
3 |
30-Nov |
338 |
3 |
29-Nov |
338 |
3 |
6-Dec |
339 |
4 |
5-Dec |
339 |
4 |
4-Dec |
339 |
4 |
3-Dec |
339 |
4 |
2-Dec |
339 |
4 |
1-Dec |
339 |
4 |
30-Nov |
339 |
4 |
7-Dec |
340 |
5 |
6-Dec |
340 |
5 |
5-Dec |
340 |
5 |
4-Dec |
340 |
5 |
3-Dec |
340 |
5 |
2-Dec |
340 |
5 |
1-Dec |
340 |
5 |
8-Dec |
341 |
6 |
7-Dec |
341 |
6 |
6-Dec |
341 |
6 |
5-Dec |
341 |
6 |
4-Dec |
341 |
6 |
3-Dec |
341 |
6 |
2-Dec |
341 |
6 |
9-Dec |
342 |
7 |
8-Dec |
342 |
7 |
7-Dec |
342 |
7 |
6-Dec |
342 |
7 |
5-Dec |
342 |
7 |
4-Dec |
342 |
7 |
3-Dec |
342 |
7 |
10-Dec |
343 |
1 |
9-Dec |
343 |
1 |
8-Dec |
343 |
1 |
7-Dec |
343 |
1 |
6-Dec |
343 |
1 |
5-Dec |
343 |
1 |
4-Dec |
343 |
1 |
11-Dec |
344 |
2 |
10-Dec |
344 |
2 |
9-Dec |
344 |
2 |
8-Dec |
344 |
2 |
7-Dec |
344 |
2 |
6-Dec |
344 |
2 |
5-Dec |
344 |
2 |
12-Dec |
345 |
3 |
11-Dec |
345 |
3 |
10-Dec |
345 |
3 |
9-Dec |
345 |
3 |
8-Dec |
345 |
3 |
7-Dec |
345 |
3 |
6-Dec |
345 |
3 |
13-Dec |
346 |
4 |
12-Dec |
346 |
4 |
11-Dec |
346 |
4 |
10-Dec |
346 |
4 |
9-Dec |
346 |
4 |
8-Dec |
346 |
4 |
7-Dec |
346 |
4 |
14-Dec |
347 |
5 |
13-Dec |
347 |
5 |
12-Dec |
347 |
5 |
11-Dec |
347 |
5 |
10-Dec |
347 |
5 |
9-Dec |
347 |
5 |
8-Dec |
347 |
5 |
15-Dec |
348 |
6 |
14-Dec |
348 |
6 |
13-Dec |
348 |
6 |
12-Dec |
348 |
6 |
11-Dec |
348 |
6 |
10-Dec |
348 |
6 |
9-Dec |
348 |
6 |
16-Dec |
349 |
6 |
15-Dec |
349 |
6 |
14-Dec |
349 |
6 |
13-Dec |
349 |
6 |
12-Dec |
349 |
6 |
11-Dec |
349 |
6 |
10-Dec |
349 |
7 |
17-Dec |
350 |
0 |
16-Dec |
350 |
0 |
15-Dec |
350 |
0 |
14-Dec |
350 |
0 |
13-Dec |
350 |
0 |
12-Dec |
350 |
0 |
11-Dec |
350 |
1 |
18-Dec |
351 |
1 |
17-Dec |
351 |
1 |
16-Dec |
351 |
1 |
15-Dec |
351 |
1 |
14-Dec |
351 |
1 |
13-Dec |
351 |
1 |
12-Dec |
351 |
2 |
19-Dec |
352 |
2 |
18-Dec |
352 |
2 |
17-Dec |
352 |
2 |
16-Dec |
352 |
2 |
15-Dec |
352 |
2 |
14-Dec |
352 |
2 |
13-Dec |
352 |
3 |
20-Dec |
353 |
3 |
19-Dec |
353 |
3 |
18-Dec |
353 |
3 |
17-Dec |
353 |
3 |
16-Dec |
353 |
3 |
15-Dec |
353 |
3 |
14-Dec |
353 |
4 |
21-Dec |
354 |
4 |
20-Dec |
354 |
4 |
19-Dec |
354 |
4 |
18-Dec |
354 |
4 |
17-Dec |
354 |
4 |
16-Dec |
354 |
4 |
15-Dec |
354 |
5 |
22-Dec |
355 |
5 |
21-Dec |
355 |
5 |
20-Dec |
355 |
5 |
19-Dec |
355 |
5 |
18-Dec |
355 |
5 |
17-Dec |
355 |
5 |
16-Dec |
355 |
6 |
23-Dec |
356 |
6 |
22-Dec |
356 |
6 |
21-Dec |
356 |
6 |
20-Dec |
356 |
6 |
19-Dec |
356 |
6 |
18-Dec |
356 |
6 |
17-Dec |
356 |
7 |
24-Dec |
357 |
0 |
23-Dec |
357 |
0 |
22-Dec |
357 |
0 |
21-Dec |
357 |
0 |
20-Dec |
357 |
0 |
19-Dec |
357 |
0 |
18-Dec |
357 |
1 |
25-Dec |
358 |
1 |
24-Dec |
358 |
1 |
23-Dec |
358 |
1 |
22-Dec |
358 |
1 |
21-Dec |
358 |
1 |
20-Dec |
358 |
1 |
19-Dec |
358 |
2 |
26-Dec |
359 |
2 |
25-Dec |
359 |
2 |
24-Dec |
359 |
2 |
23-Dec |
359 |
2 |
22-Dec |
359 |
2 |
21-Dec |
359 |
2 |
20-Dec |
359 |
3 |
27-Dec |
360 |
3 |
26-Dec |
360 |
3 |
25-Dec |
360 |
3 |
24-Dec |
360 |
3 |
23-Dec |
360 |
3 |
22-Dec |
360 |
3 |
21-Dec |
360 |
4 |
28-Dec |
361 |
4 |
27-Dec |
361 |
4 |
26-Dec |
361 |
4 |
25-Dec |
361 |
4 |
24-Dec |
361 |
4 |
23-Dec |
361 |
4 |
22-Dec |
361 |
5 |
29-Dec |
362 |
5 |
28-Dec |
362 |
5 |
27-Dec |
362 |
5 |
26-Dec |
362 |
5 |
25-Dec |
362 |
5 |
24-Dec |
362 |
5 |
23-Dec |
362 |
6 |
30-Dec |
363 |
6 |
29-Dec |
363 |
6 |
28-Dec |
363 |
6 |
27-Dec |
363 |
6 |
26-Dec |
363 |
6 |
25-Dec |
363 |
6 |
24-Dec |
363 |
7 |
31-Dec |
364 |
0 |
30-Dec |
364 |
0 |
29-Dec |
364 |
0 |
28-Dec |
364 |
0 |
27-Dec |
364 |
0 |
26-Dec |
364 |
0 |
25-Dec |
364 |
1 |
|
365 |
|
31-Dec |
365 |
1 |
30-Dec |
365 |
1 |
29-Dec |
365 |
1 |
28-Dec |
365 |
1 |
27-Dec |
365 |
1 |
26-Dec |
365 |
2 |
|
366 |
|
|
366 |
|
31-Dec |
366 |
2 |
30-Dec |
366 |
2 |
29-Dec |
366 |
2 |
28-Dec |
366 |
2 |
27-Dec |
366 |
3 |
|
367 |
|
|
367 |
|
|
367 |
|
31-Dec |
367 |
3 |
30-Dec |
367 |
3 |
29-Dec |
367 |
3 |
28-Dec |
367 |
4 |
|
368 |
|
|
368 |
|
|
368 |
|
|
368 |
|
31-Dec |
368 |
4 |
30-Dec |
368 |
4 |
29-Dec |
368 |
5 |
|
369 |
|
|
369 |
|
|
369 |
|
|
369 |
|
|
369 |
|
31-Dec |
369 |
5 |
30-Dec |
369 |
6 |
|
370 |
|
|
370 |
|
|
370 |
|
|
370 |
|
|
370 |
|
|
370 |
|
31-Dec |
370 |
7 |
(EXCEL Users) Link to the Spreadsheet
Calendar for Years with 365 days |
|
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Start on Sunday |
|
|
|
|
|
|
|
|
|
|
|
|
||
1-Jan |
1 |
Start on Monday |
|
|
|
|
|
|
|
|
|
|
||
2-Jan |
2 |
1-Jan |
2 |
Start on Tuesday |
|
|
|
|
|
|
|
|
||
3-Jan |
3 |
2-Jan |
3 |
1-Jan |
3 |
Start on Wednesday |
|
|
|
|
|
|
||
4-Jan |
4 |
3-Jan |
4 |
2-Jan |
4 |
1-Jan |
4 |
Start on Thursday |
|
|
|
|
||
5-Jan |
5 |
4-Jan |
5 |
3-Jan |
5 |
2-Jan |
5 |
1-Jan |
5 |
Start on Friday |
|
|
||
6-Jan |
6 |
5-Jan |
6 |
4-Jan |
6 |
3-Jan |
6 |
2-Jan |
6 |
1-Jan |
6 |
Start on Saturday |
||
7-Jan |
7 |
6-Jan |
7 |
5-Jan |
7 |
4-Jan |
7 |
3-Jan |
7 |
2-Jan |
7 |
1-Jan |
7 |
|
8-Jan |
1 |
7-Jan |
1 |
6-Jan |
1 |
5-Jan |
1 |
4-Jan |
1 |
3-Jan |
1 |
2-Jan |
1 |
|
9-Jan |
2 |
8-Jan |
2 |
7-Jan |
2 |
6-Jan |
2 |
5-Jan |
2 |
4-Jan |
2 |
3-Jan |
2 |
|
10-Jan |
3 |
9-Jan |
3 |
8-Jan |
3 |
7-Jan |
3 |
6-Jan |
3 |
5-Jan |
3 |
4-Jan |
3 |
|
11-Jan |
4 |
10-Jan |
4 |
9-Jan |
4 |
8-Jan |
4 |
7-Jan |
4 |
6-Jan |
4 |
5-Jan |
4 |
|
12-Jan |
5 |
11-Jan |
5 |
10-Jan |
5 |
9-Jan |
5 |
8-Jan |
5 |
7-Jan |
5 |
6-Jan |
5 |
|
13-Jan |
6 |
12-Jan |
6 |
11-Jan |
6 |
10-Jan |
6 |
9-Jan |
6 |
8-Jan |
6 |
7-Jan |
6 |
|
17-Feb |
6 |
16-Feb |
6 |
15-Feb |
6 |
14-Feb |
6 |
13-Feb |
6 |
12-Feb |
6 |
11-Feb |
6 |
|
17-Mar |
6 |
16-Mar |
6 |
15-Mar |
6 |
14-Mar |
6 |
13-Mar |
6 |
12-Mar |
6 |
11-Mar |
6 |
|
14-Apr |
6 |
13-Apr |
6 |
12-Apr |
6 |
11-Apr |
6 |
10-Apr |
6 |
9-Apr |
6 |
8-Apr |
6 |
|
19-May |
6 |
18-May |
6 |
17-May |
6 |
16-May |
6 |
15-May |
6 |
14-May |
6 |
13-May |
6 |
|
16-Jun |
6 |
15-Jun |
6 |
14-Jun |
6 |
13-Jun |
6 |
12-Jun |
6 |
11-Jun |
6 |
10-Jun |
6 |
|
14-Jul |
6 |
13-Jul |
6 |
12-Jul |
6 |
11-Jul |
6 |
10-Jul |
6 |
9-Jul |
6 |
8-Jul |
6 |
|
18-Aug |
6 |
17-Aug |
6 |
16-Aug |
6 |
15-Aug |
6 |
14-Aug |
6 |
13-Aug |
6 |
12-Aug |
6 |
|
15-Sep |
6 |
14-Sep |
6 |
13-Sep |
6 |
12-Sep |
6 |
11-Sep |
6 |
10-Sep |
6 |
9-Sep |
6 |
|
13-Oct |
6 |
12-Oct |
6 |
11-Oct |
6 |
10-Oct |
6 |
9-Oct |
6 |
8-Oct |
6 |
7-Oct |
6 |
|
17-Nov |
6 |
16-Nov |
6 |
15-Nov |
6 |
14-Nov |
6 |
13-Nov |
6 |
12-Nov |
6 |
11-Nov |
6 |
|
15-Dec |
6 |
14-Dec |
6 |
13-Dec |
6 |
12-Dec |
6 |
11-Dec |
6 |
10-Dec |
6 |
9-Dec |
6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
2 |
|
2 |
|
2 |
|
1 |
|
3 |
|
1 |
|
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Start on Sunday |
|
|
|
|
|
|
|
|
|
|
|
|
||
1-Jan |
0 |
Start on Monday |
|
|
|
|
|
|
|
|
|
|
||
2-Jan |
1 |
1-Jan |
1 |
Start on Tuesday |
|
|
|
|
|
|
|
|
||
3-Jan |
2 |
2-Jan |
2 |
1-Jan |
2 |
Start on Wednesday |
|
|
|
|
|
|
||
4-Jan |
3 |
3-Jan |
3 |
2-Jan |
3 |
1-Jan |
3 |
Start on Thursday |
|
|
|
|
||
5-Jan |
4 |
4-Jan |
4 |
3-Jan |
4 |
2-Jan |
4 |
1-Jan |
4 |
Start on Friday |
|
|
||
6-Jan |
5 |
5-Jan |
5 |
4-Jan |
5 |
3-Jan |
5 |
2-Jan |
5 |
1-Jan |
5 |
Start on Saturday |
||
7-Jan |
6 |
6-Jan |
6 |
5-Jan |
6 |
4-Jan |
6 |
3-Jan |
6 |
2-Jan |
6 |
1-Jan |
6 |
|
8-Jan |
0 |
7-Jan |
0 |
6-Jan |
0 |
5-Jan |
0 |
4-Jan |
0 |
3-Jan |
0 |
2-Jan |
0 |
|
9-Jan |
1 |
8-Jan |
1 |
7-Jan |
1 |
6-Jan |
1 |
5-Jan |
1 |
4-Jan |
1 |
3-Jan |
1 |
|
10-Jan |
2 |
9-Jan |
2 |
8-Jan |
2 |
7-Jan |
2 |
6-Jan |
2 |
5-Jan |
2 |
4-Jan |
2 |
|
11-Jan |
3 |
10-Jan |
3 |
9-Jan |
3 |
8-Jan |
3 |
7-Jan |
3 |
6-Jan |
3 |
5-Jan |
3 |
|
12-Jan |
4 |
11-Jan |
4 |
10-Jan |
4 |
9-Jan |
4 |
8-Jan |
4 |
7-Jan |
4 |
6-Jan |
4 |
|
13-Jan |
5 |
12-Jan |
5 |
11-Jan |
5 |
10-Jan |
5 |
9-Jan |
5 |
8-Jan |
5 |
7-Jan |
5 |
|
17-Feb |
5 |
16-Feb |
5 |
15-Feb |
5 |
14-Feb |
5 |
13-Feb |
5 |
12-Feb |
5 |
11-Feb |
5 |
|
16-Mar |
5 |
15-Mar |
5 |
14-Mar |
5 |
13-Mar |
5 |
12-Mar |
5 |
11-Mar |
5 |
10-Mar |
5 |
|
13-Apr |
5 |
12-Apr |
5 |
11-Apr |
5 |
10-Apr |
5 |
9-Apr |
5 |
8-Apr |
5 |
7-Apr |
5 |
|
18-May |
5 |
17-May |
5 |
16-May |
5 |
15-May |
5 |
14-May |
5 |
13-May |
5 |
12-May |
5 |
|
15-Jun |
5 |
14-Jun |
5 |
13-Jun |
5 |
12-Jun |
5 |
11-Jun |
5 |
10-Jun |
5 |
9-Jun |
5 |
|
13-Jul |
5 |
12-Jul |
5 |
11-Jul |
5 |
10-Jul |
5 |
9-Jul |
5 |
8-Jul |
5 |
7-Jul |
5 |
|
17-Aug |
5 |
16-Aug |
5 |
15-Aug |
5 |
14-Aug |
5 |
13-Aug |
5 |
12-Aug |
5 |
11-Aug |
5 |
|
14-Sep |
5 |
13-Sep |
5 |
12-Sep |
5 |
11-Sep |
5 |
10-Sep |
5 |
9-Sep |
5 |
8-Sep |
5 |
|
19-Oct |
5 |
18-Oct |
5 |
17-Oct |
5 |
16-Oct |
5 |
15-Oct |
5 |
14-Oct |
5 |
13-Oct |
5 |
|
16-Nov |
5 |
15-Nov |
5 |
14-Nov |
5 |
13-Nov |
5 |
12-Nov |
5 |
11-Nov |
5 |
10-Nov |
5 |
|
14-Dec |
5 |
13-Dec |
5 |
12-Dec |
5 |
11-Dec |
5 |
10-Dec |
5 |
9-Dec |
5 |
8-Dec |
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
3 |
|
2 |
|
1 |
|
2 |
|
2 |
|
1 |
|
1 |
|
|
(EXCEL Users) Link to the Spreadsheet
The only months where Friday the 13th falls in each month would require a month that has the numbers of days within the month evenly divisible by 7. In the calendar in use, the only month with that criteria is February, and only February, when it is not a leap year. (otherwise there would be 29 days) So whenever it is not a leap year, and there is a Friday the 13th in February, there will be a Friday the 13th in March. Since there are no leap years that contain months where the modulus of the days in the month divided by 7 results in 0, leap years will not have consecutive months with Friday the 13ths.
As can be seen quickly from the spreadsheet, this occurs whenever the first of the year falls on a Thursday. It can also be seen that we want the 13th of February, which is the 44th day of the year, to fall on a Friday. (31 days of January plus the 13 days of February). When January 1 falls on a Sunday, this means that the 13th of February falls on:
Mod((44-1),7) = 2; or Tuesday.
Note that we started with Sunday, January 1st as “0”, making the 13th of February “44th –1”). Note that when the modulus = 0, we will have a Sunday. (1 for Monday…etc.)
This means that:
Mod((44-x),7) = 5, when we want to know when Feb. 13th falls on a Friday.
Solving for x, we come up with x = 4; or Thursday.
Next is to determine when the next time we’ll have a year with 3 Friday the 13th. We have two items to look for:
Column A: This column should contain the date field of January 1 for each year desired. The column I suggest should start with 1998, which was the last year we had 3 Friday the 13th’s. This column of data can be easily constructed by entering the first 3 dates (01-Jan-98, 01-Jan-99, 01-Jan-00) and then auto constructing the remaining dates (highlight the 3, find the lower corner and drag down through the years) I suggest you only take this out to year 2099. (Note that 2100 is not a leap year…)
Column B: This column will contain a formula for determining whether January 1 is the day of the week we desire. EXCEL provides a function called “WEEKDAY”. This function requires you to enter a date and then it will return a numeric value corresponding to the day of the week, for the date entered. There are options as to the format it returns the day of the week. In our case, we want to use a numeric value of from 1 to 7, where 1 corresponds to Sunday and 7 corresponds to Saturday. Our key days of the week for starting are Thursday (for non-Leap Years) and Sunday )for Leap Years.
Along with the use of WEEKDAY, we will also use a conditional (“IF”) to allow us to flag the years that have 3 Friday the 13ths. In this case, we will compare the day of the week we received for 01-Jan with the day of the week we need for a 3 Friday the 13th year. If they match, then we’ll display “3 Friday the 13th”. The values we want to compare against will be in Column C of the same row as the date in Column A. The EXCEL statement will look like:
=IF(WEEKDAY(Column A Location,1)=Value in Column C location, "3 Fri 13th"," ")
Note: “Column A” location will look like – A2
And “Value in Column C location” will look like – C2
Column C: This will contain the value of “5” (or Thursday) for non-Leap Years or the value of “1” (or Sunday) for Leap Years.
A sample of the spreadsheet is listed below:
1/1/98 |
3 Fri 13th |
5 |
1/1/99 |
|
5 |
1/1/00 |
|
1 |
1/1/01 |
|
5 |
1/1/02 |
|
5 |
1/1/03 |
|
5 |
1/1/04 |
|
1 |
1/1/05 |
|
5 |
1/1/06 |
|
5 |
1/1/07 |
|
5 |
1/1/08 |
|
1 |
1/1/09 |
3 Fri 13th |
5 |
1/1/10 |
|
5 |
1/1/11 |
|
5 |
1/1/12 |
3 Fri 13th |
1 |
1/1/13 |
|
5 |
.
.
.
1/1/86 |
|
5 |
1/1/87 |
|
5 |
1/1/88 |
|
1 |
1/1/89 |
|
5 |
1/1/90 |
|
5 |
1/1/91 |
|
5 |
1/1/92 |
|
1 |
1/1/93 |
3 Fri 13th |
5 |
1/1/94 |
|
5 |
1/1/95 |
|
5 |
1/1/96 |
3 Fri 13th |
1 |
1/1/97 |
|
5 |
1/1/98 |
|
5 |
1/1/99 |
3 Fri 13th |
5 |
(EXCEL Users) Link to the Spreadsheet
It is clear to see from the spreadsheet that there is a 28 year cycle. If we start with Year 2000, we see the “3 Friday the 13th” years showing up 9, 12, 15 and 26 years into the cycle. Similarly, we see the same 9/12/15/26 year cycle starting in Year 2028 (Years, 2037, 2041, 2044 and 2054). The question is why do we have a 28 year cycle?
The key to resolving this issue is to note that we have 2 sequences we are looking at.
If Modulus(# days per year,# of days per week) not equal 0, then we have a 7 year cycle.
Why? The number of days needed to repeat a cycle is:
Lowest common multiple of the number of days of the week and the number of days we move ahead, divided by the number of days we move ahead. Since 7 is prime, the lowest common multiple, will always be a direct factor of the number of days we move ahead, leaving us with the value of 7. i.e.
Modulus * 7 / Modulus à 7 cycles.
If Modulus(# days per year, # days per week) equals 0, then we have an annual cycle (same each year)
So we need a cycle of 7 years, if all the years are the same length. Now when we add in a leap year every 4th year, we again, look for the lowest common multiple of 4 and 7, which results in 28 years.
Of interest is to experiment with other number of days per
week (preferably non-prime) and 6 day weeks and years other than 365 and
366. This would be the challenge,
either by spreadsheet or by calculation as to what would be expected.