Date_Calendar.xlsx

	A	B	C	D	E	H	I	J	K	L	M	O	P
1	Date	Date in Number	Date	Month	Year		Running sr no	Days in month	Cum days till end of month from beg of year	Mon	Day	Set of years	Odd days for the set
2	7-Sep-1929	7-Sep-1929	7	9	1929		0	0	0	Zer	Sun	1	1
3							1	31	31	Jan	Mon	4	5
4	From Agarwal book: pg 593		Calendar reference		https://www.timeanddate.com/calendar/?year=2018&country=1		2	28	59	Feb	Tue	100	5
5			Odd days	Remarks			3	31	90	Mar	Wed	400	0
6	Years in multiples of 400	1600		Odd days for every 400 years Is zero			4	30	120	Apr	Thu
7	Years from multiple of 400	329					5	31	151	May	Fri
8	Number of 100 years	3	15	Odd days for every 100 years Is 5			6	30	181	Jun	Sat
9	Years from multiple of 100	28		Current or last year should not be counted			7	31	212	Jul
10	Number of 4 years	7	35	Odd days for every 4 years Is 5			8	31	243	Aug
11	Years from multiple of 4	0	0	Odd days for every year Is 1			9	30	273	Sep
12	Month	Aug		Current month should not be counted			10	31	304	Oct
13	Upto end of month	Aug	5	Odd days upto end of prev month since beginning of current year			11	30	334	Nov
14	Date	7	0	Odd days till current date in the current month			12	31	365	Dec
15
16	Sum		55
17	Odd reminder		6			Every 100th year is not a leap year.
18	Day of the week		Sat			But every 400th year is a leap year
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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