Tạo lịch 12 tháng bằng Excel

Jan Apr Jul Oct Feb May Aug Nov Mar Jun Sep Dec
1/1/2014 4/1/2014 7/1/2014 10/1/2014 28 2/1/2014 5/1/2014 8/1/2014 11/1/2014 3/1/2014 6/1/2014 9/1/2014 12/1/2014
Jan 1 Feb 1 Mar 1
Apr 1 May 1 Jun 1
Jul 1 Aug 1 Sep 1
Oct 1 Nov 1 Dec 1

Enter year for calendar: 2014 CHANGE THE YEAR HERE
(1900 - 2078)


CALENDER FOR 2014








JANUARY FEBRUARY MARCH
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
1 1 2 3 4 5 1 9 1
2 5 6 7 8 9 10 11 6 2 3 4 5 6 7 8 10 2 3 4 5 6 7 8
3 12 13 14 15 16 17 18 7 9 10 11 12 13 14 15 11 9 10 11 12 13 14 15
4 19 20 21 22 23 24 25 8 16 17 18 19 20 21 22 12 16 17 18 19 20 21 22
5 26 27 28 29 30 31 9 23 24 25 26 27 28 13 23 24 25 26 27 28 29
14 30 31






APRIL MAY JUNE
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
14 1 2 3 4 5 18 1 2 3 22 1 2 3 4 5 6 7
15 6 7 8 9 10 11 12 19 4 5 6 7 8 9 10 23 8 9 10 11 12 13 14
16 13 14 15 16 17 18 19 20 11 12 13 14 15 16 17 24 15 16 17 18 19 20 21
17 20 21 22 23 24 25 26 21 18 19 20 21 22 23 24 25 22 23 24 25 26 27 28
18 27 28 29 30 22 25 26 27 28 29 30 31 26 29 30







JULY AUGUST SEPTEMBER
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
27 1 2 3 4 5 31 1 2 36 1 2 3 4 5 6
28 6 7 8 9 10 11 12 32 3 4 5 6 7 8 9 37 7 8 9 10 11 12 13
29 13 14 15 16 17 18 19 33 10 11 12 13 14 15 16 38 14 15 16 17 18 19 20
30 20 21 22 23 24 25 26 34 17 18 19 20 21 22 23 39 21 22 23 24 25 26 27
31 27 28 29 30 31 35 24 25 26 27 28 29 30 40 28 29 30
36 31






OCTOBER NOVEMBER DECEMBER
WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT WK SUN MON TUE WED THU FRI SAT
41 1 2 3 4 45 1 50 1 2 3 4 5 6
42 5 6 7 8 9 10 11 46 2 3 4 5 6 7 8 51 7 8 9 10 11 12 13
43 12 13 14 15 16 17 18 47 9 10 11 12 13 14 15 52 14 15 16 17 18 19 20
44 19 20 21 22 23 24 25 48 16 17 18 19 20 21 22 53 21 22 23 24 25 26 27
45 26 27 28 29 30 31 49 23 24 25 26 27 28 29 54 28 29 30 31
50 30

Happy New Year :)