Yearly Calendar
January 2020 - December 2020
January 2020 1 February 2020 2 March 2020 3
S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa
1 2 3 4 1 1 2 3 4 5 6 7
5 6 7 8 9 10 11 2 3 4 5 6 7 8 8 9 10 11 12 13 14
12 13 14 15 16 17 18 9 10 11 12 13 14 15 15 16 17 18 19 20 21
19 20 21 22 23 24 25 16 17 18 19 20 21 22 22 23 24 25 26 27 28
26 27 28 29 30 31 23 24 25 26 27 28 29 29 30 31
April 2020 4 May 2020 5 June 2020 6
S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa
1 2 3 4 1 2 1 2 3 4 5 6
5 6 7 8 9 10 11 3 4 5 6 7 8 9 7 8 9 10 11 12 13
12 13 14 15 16 17 18 10 11 12 13 14 15 16 14 15 16 17 18 19 20
19 20 21 22 23 24 25 17 18 19 20 21 22 23 21 22 23 24 25 26 27
26 27 28 29 30 24 25 26 27 28 29 30 28 29 30
31
July 2020 7 August 2020 8 September 2020 9
S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa
1 2 3 4 1 1 2 3 4 5
5 6 7 8 9 10 11 2 3 4 5 6 7 8 6 7 8 9 10 11 12
12 13 14 15 16 17 18 9 10 11 12 13 14 15 13 14 15 16 17 18 19
19 20 21 22 23 24 25 16 17 18 19 20 21 22 20 21 22 23 24 25 26
26 27 28 29 30 31 23 24 25 26 27 28 29 27 28 29 30
30 31
October 2020 10 November 2020 11 December 2020 12
S M T W Th F Sa S M T W Th F Sa S M T W Th F Sa
1 2 3 1 2 3 4 5 6 7 1 2 3 4 5
4 5 6 7 8 9 10 8 9 10 11 12 13 14 6 7 8 9 10 11 12
11 12 13 14 15 16 17 15 16 17 18 19 20 21 13 14 15 16 17 18 19
18 19 20 21 22 23 24 22 23 24 25 26 27 28 20 21 22 23 24 25 26
25 26 27 28 29 30 31 29 30 27 28 29 30 31
Months startDate 2020/1/1
January
February
March
April
May
June
July
August
September
October
November
December
Method for creating a monthly calendar without using arrays Using arrays
January 2020
Sun Mon Tue Wed Thu Fri Sat January 2020
1 2 3 4 5 6 7 S
1 1 2 3 4
2 5 6 7 8 9 10 11 5
3 12 13 14 15 16 17 18 12
4 19 20 21 22 23 24 25 19
5 26 27 28 29 30 31 26
6
monthNames startDates
January 2020/1/1
February 2020/2/1
March 2020/3/1
April 2020/4/1
May 2020/5/1
June 2020/6/1
July 2020/7/1
August 2020/8/1
September 2020/9/1
October 2020/10/1
November 2020/11/1
December 2020/12/1
January 2021/1/1
February 2021/2/1
March 2021/3/1
April 2021/4/1
May 2021/5/1
June 2021/6/1
July 2021/7/1
August 2021/8/1
September 2021/9/1
October 2021/10/1
November 2021/11/1
December 2021/12/1
Adding additional months:
Insert a new row (before the
last month in the list) and
copy the formulas down.
How it Works:
This calendar is included to show how the
more complex array function works. Note
the use of mixed absolute and relative
references that enable you to copy the
formula down and across. This is basically
what the array formula is doing for you.
Month Names:
This named range (months)
is used as the input for the
combo box.
The Start Date:
This named formula (startDate) is
the first day of the first month in
the yearly calendar, defined by the
month and year chosen by the
user.
January 2022/1/1
February 2022/2/1
Adding additional months:
Insert a new row (before the
last month in the list) and
copy the formulas down.
M T W Th F Sa
1 2 3 4
6 7 8 9 10 11
13 14 15 16 17 18
20 21 22 23 24 25
27 28 29 30 31
Using arrays
January 2020
