2005
January
Week ###### ###### 3 4 11 18 25 5 12 19 26 6 13 20 27 7 14 21 28 ###### 10 ###### 17 ###### 24 ###### 31 Mo Tu We Th Fr Sa Su 1 8 15 22 29 2 9 16 23 30 Week ###### ###### 7 ###### 14 ###### 21 ###### 28
February
Mo Tu We Th Fr 1 8 15 22 2 9 16 23 3 10 17 24 4 11 18 25 Sa Su 5 12 19 26 6 13 20 27 Week ###### ###### 7 ###### 14 ###### 21 ###### 28
March
Mo Tu We Th Fr 1 8 15 22 29 2 9 16 23 30 3 10 17 24 31 4 11 18 25 Sa Su 5 12 19 26 6 13 20 27
(Norwgian) Public holidays New Year's Day Palm Sunday Maundy Thursday Good Friday Easter Sunday Easter Monday 1. May Norwegian Constitution Day Sa Su 4 11 18 25 5 12 19 26 Ascension Day Whitsunday Whit Monday Advent (First Sunday) Christmas Day Boxing Day 2005-01-01 #NAME? #NAME? #NAME? #NAME? #NAME? 2005-05-01 2005-05-17 #NAME? #NAME? #NAME? #NAME? 2005-12-25 2005-12-26
April
Week ###### ###### 4 5 12 19 26 6 13 20 27 7 14 21 28 ###### 11 ###### 18 ###### 25 Mo Tu We Th Fr 1 8 15 22 29 Sa Su 2 9 16 23 30 3 10 17 24 Week ###### ###### ###### 2 9 3 10 17 24 31
May
Mo Tu We Th Fr 4 11 18 25 5 12 19 26 6 13 20 27 Sa Su 1 7 14 21 28 8 15 22 29 Week ###### ###### 6 7 14 21 28 ###### 13 ###### 20 ###### 27
June
Mo Tu We Th Fr 1 8 15 22 29 2 9 16 23 30 3 10 17 24
###### 16 ###### 23 ###### 30
July
Week ###### ###### 4 5 12 19 26 6 13 20 27 7 14 21 28 ###### 11 ###### 18 ###### 25 Mo Tu We Th Fr 1 8 15 22 29 Sa Su 2 9 16 23 30 3 10 17 24 31 Week ###### ###### 1 8
August
Mo Tu We Th Fr 2 9 16 23 30 3 10 17 24 31 4 11 18 25 5 12 19 26 Sa Su 6 13 20 27 7 14 21 28 Week ###### ###### 5
September
Mo Tu We Th Fr 1 6 13 20 27 7 14 21 28 8 15 22 29 2 9 16 23 30 Sa Su 3 10 17 24 4 11 18 25
Notes
###### 15 ###### 22 ###### 29
###### 12 ###### 19 ###### 26
October
Week ###### ###### 3 4 11 18 25 5 12 19 26 6 13 20 27 7 14 21 28 ###### 10 ###### 17 ###### 24 ###### 31 Mo Tu We Th Fr Sa Su 1 8 15 22 29 2 9 16 23 30 Week ###### ###### 7 ###### 14 ###### 21 ###### 28
November
Mo Tu We Th Fr 1 8 15 22 29 2 9 16 23 30 3 10 17 24 4 11 18 25 Sa Su 5 12 19 26 6 13 20 27 Week ###### ###### 5
December
Mo Tu We Th Fr 1 6 13 20 27 7 14 21 28 8 15 22 29 2 9 16 23 30 Sa Su 3 10 17 24 31 4 11 18 25
###### 12 ###### 19 ###### 26
Created by Nikolai Sandved on 2003-04-03 19:04 Last Saved by Nikolai on 2006-01-22 00:26
C:\Documents and Settings\Nikolai\Skrivebord\ProbabilityOf.com\excel\a84ac21e-ce97-4346-8db8-0cdd8907af23.xls - Calendar (English) (1/4)
2005
Januar
Uke ###### ###### 3 4 11 18 25 5 12 19 26 6 13 20 27 7 14 21 28 ###### 10 ###### 17 ###### 24 ###### 31 Ma Ti On To Fr Lø 1 8 15 22 29 Sø 2 9 16 23 30 Uke ###### ###### 7 ###### 14 ###### 21 ###### 28
Februar
Ma Ti 1 8 15 22 On To Fr 2 9 16 23 3 10 17 24 4 11 18 25 Lø 5 12 19 26 Sø 6 13 20 27 Uke ###### ###### 7 ###### 14 ###### 21 ###### 28 Ma Ti 1 8 15 22 29
Mars
On To Fr 2 9 16 23 30 3 10 17 24 31 4 11 18 25 Lø 5 12 19 26 Sø 6 13 20 27
Norske helligdager 1. nyttårsdag Palmesøndag Skjærtorsdag Langfredag 1. påskedag 2. påskedag 1. mai Grunnlovsdag Lø 4 11 18 25 Sø 5 12 19 26 Kristi himmelfartsdag 1. pinsedag 2. pinsedag 1. søndag i advent 1. juledag 2 juledag 2005-01-01 #NAME? #NAME? #NAME? #NAME? #NAME? 2005-05-01 2005-05-17 #NAME? #NAME? #NAME? #NAME? 2005-12-25 2005-12-26
April
Uke ###### ###### 4 5 12 19 26 6 13 20 27 7 14 21 28 ###### 11 ###### 18 ###### 25 Ma Ti On To Fr 1 8 15 22 29 Lø 2 9 16 23 30 Sø 3 10 17 24 Uke ###### ###### ###### 2 9 3 10 17 24 31 Ma Ti
Mai
On To Fr 4 11 18 25 5 12 19 26 6 13 20 27 Lø 7 14 21 28 Sø 1 8 15 22 29 Uke ###### ###### 6 7 14 21 28 ###### 13 ###### 20 ###### 27 Ma Ti
Juni
On To Fr 1 8 15 22 29 2 9 16 23 30 3 10 17 24
###### 16 ###### 23 ###### 30
Juli
Uke ###### ###### 4 5 12 19 26 6 13 20 27 7 14 21 28 ###### 11 ###### 18 ###### 25 Ma Ti On To Fr 1 8 15 22 29 Lø 2 9 16 23 30 Sø 3 10 17 24 31 Uke ###### ###### 1 8
August
Ma Ti 2 9 16 23 30 On To Fr 3 10 17 24 31 4 11 18 25 5 12 19 26 Lø 6 13 20 27 Sø 7 14 21 28 Uke ###### ###### 5
September
Ma Ti 6 13 20 27 On To Fr 1 7 14 21 28 8 15 22 29 2 9 16 23 30 Lø 3 10 17 24 Sø 4 11 18 25
Notater
###### 15 ###### 22 ###### 29
###### 12 ###### 19 ###### 26
Oktober
Uke ###### ###### 3 4 11 18 25 5 12 19 26 6 13 20 27 7 14 21 28 ###### 10 ###### 17 ###### 24 ###### 31 Ma Ti On To Fr Lø 1 8 15 22 29 Sø 2 9 16 23 30 Uke ###### ###### 7 ###### 14 ###### 21 ###### 28
November
Ma Ti 1 8 15 22 29 On To Fr 2 9 16 23 30 3 10 17 24 4 11 18 25 Lø 5 12 19 26 Sø 6 13 20 27 Uke ###### ###### 5
Desember
Ma Ti 6 13 20 27 On To Fr 1 7 14 21 28 8 15 22 29 2 9 16 23 30 Lø 3 10 17 24 31 Sø 4 11 18 25
###### 12 ###### 19 ###### 26
Created by Nikolai Sandved on 2003-04-03 19:04 Last Saved by Nikolai on 2006-01-22 00:26
C:\Documents and Settings\Nikolai\Skrivebord\ProbabilityOf.com\excel\a84ac21e-ce97-4346-8db8-0cdd8907af23.xls - Kalender (Norsk) (2/4)
How to use In the Calendar-view, write the year in Cell B3 The full Calendar will now automatically be calculated Public holidays appears on the Right hand side (including Easter) Error messages If #NAME()! Or ### in Week/Uke you need to enable macro to run-> Goto Tools-> Macro -> Security … Set to Medium Close Excel and open Excel and this File again
More information The Calendar follows the ISO 8601 standard regarding Week numbering and Monday as first day of week. Calculation of the Easter date is done by using a algothm appearing in The Calendar FAQ The calulation in the calendar have not been thoroughly tested. But the Easter calculation should be correct for every year. NB: Dates before 1900-03-31 is one day wrong in Excel since Excel assumes that 1900 is a leap year! Sources Advent Calculation - http://www.smart.net/~mmontes/ec-cal.html Easter - http://www.ortelius.de/kalender/east_en.html Easter date FAQ - http://www.cs.rutgers.edu/pub/soc.religion.christian/faq/easter-date Easter date Formula () - http://astro.nmsu.edu/~lhuber/leaphist.html Easter date formula (Calendar FAQ)- http://www.tondering.dk/claus/cal/node3.html#SECTION003120000000000000000 Easter date formula (US Navy) - http://aa.usno.navy.mil/faq/docs/easter.html ISO 8601 - http://dmoz.org/Science/Reference/Standards/Individual_Standards/ISO_8601/ ISO 8601 - Convert - http://www.probabilityof.com/ISO8601.shtml ISO Week - http://serendipity.magnet.ch/hermetic/cal_stud/palmen/lweek1.htm Leap Year Rule - http://www.computerbooksonline.com/program/1032chap.htm#E29E11 Excel treats 1900 as a leap year - http://www.ozgrid.com/Excel/ExcelDateandTimes.htm
Created by Nikolai Sandved on 2003-04-03 19:04 Last Saved by Nikolai on 2006-01-22 00:26
C:\Documents and Settings\Nikolai\Skrivebord\ProbabilityOf.com\excel\a84ac21e-ce97-4346-8db8-0cdd8907af23.xls - User Guide (3/4)
Version 2004-04-06 2004-09-18 2005-01-06 2006-01-22
Modified by Nikolai Sandved Nikolai Sandved Nikolai Sandved Nikolai Sandved
Email Modified nsaa@pvv.org First public version appearing on http://www.pvv.org/~nsaa/ISO8601.html nsaa@pvv.org Added more description in User Guide nsaa@pvv.org Also appearing on my excel page at http://www.pvv.org/~nsaa/excel.html nsaa@probabilityof.com File moved to http://www.probabilityof.com/excel.shtml
Created by Nikolai Sandved on 2003-04-03 19:04 Last Saved by Nikolai on 2006-01-22 00:26
C:\Documents and Settings\Nikolai\Skrivebord\ProbabilityOf.com\excel\a84ac21e-ce97-4346-8db8-0cdd8907af23.xls - Version (4/4)