goinggreek.info
The Agora => Kefalonia News => Topic started by: Maik on Tuesday, 05 January, 2016 @ 06:00:12
-
Notable dates on Kefalonia, 2016
National Public Holiday
Local Public Holiday
01/01/16 Fri Protochroniá (New Year's Day) / Agios Basileios (Saint Vasilios)
06/01/16 Wed Theophánia (Epiphany)
10/02/16 Wed Agios Haralambos (Lixouri)
21/02/16 Sun Apokreas (karnavali) begins
29/02/16 Mon Leap Day
03/03/16 Thu Tsiknopempti (Meatfare Thursday)
06/03/16 Sun Kyriaki tis apokreo (Meatfare Sunday)
13/03/16 Sun Tyrofagis (Cheesefare Sunday) / Karnavali climaxes
14/03/16 Mon Kathará Deftéra (Clean Monday)
25/03/16 Fri Eikostí-pémpti Martíou (Independence Day) / Annunciation
27/03/16 Sun Daylight Saving Time (EEST/BST) begins / Easter Sunday (UK)
24/04/16 Sun Kyriaki ton Vaion (Palm Sunday)
29/04/16 Fri Megáli Paraskeví (Great Friday)
01/05/16 Sun Kyriakí tou Páscha (Easter Sunday) / Protomayiá
02/05/16 Mon Deftéra tou Páscha (Easter Monday)
03/05/16 Tue Ergatikí Protomayiá (Labour Day ['Strike Day']) moved from 01/05
17/05/16 Tue Anna Pollatou, Kefalonian gymnast, motor accident casualty 2014
21/05/16 Sat Union of Ionian Islands & Greece (1864) / Ag. Konstantinos & Eleni
09/06/16 Thu Analipsi tou Kristou (Ascension)
19/06/16 Sun Pentikostí
20/06/16 Mon Agíou Pnévmatos (Holy Spirit)
24/06/15 Wed Agios Ioanis (Tzannata) - village festival evening 23 June
26/06/16 Sun Agion Panton (All Saints)
11/07/16 Mon Agia Efimia
24/07/16 Sun Restoration of Democracy 1974 / Eleios-Pronnoi bush fire 2007
06/08/16 Sat Metamorphosis of Christ
11/08/16 Thu Anniversary of 1953 earthquakes
14/08/16 Sun Fidakia tis Panagias (Snake festival, Markopoulo, p.m.)
15/08/16 Mon Kímisi tis Theotókou (Assumption) / Fidakia tis Panagias (a.m.)
15/08/16 Mon Agios Gerasimos (Omala, p.m.)
16/08/16 Tue Agios Gerasimos (Omala, a.m.)
27/08/16 Sat Colonel Stergios Kotoulas died fire-fighting, Katelios, 2009
08/09/16 Thu Gennesíou tis Theotókou (Holy Virgin's Birthday)
14/09/16 Wed Ypsóseos tou Timíou Stavroú (Exaltation of the Holy Cross)
20/10/16 Thu Restitution of Ag. Gerasimos' Sacred Relic
28/10/16 Fri Iméra tou Okhi (OXI Day)
30/10/16 Sun European Daylight Saving Time ends
17/11/16 Thu Polytechneio
25/12/16 Sun Kristoúyenna (Christmas Day)
26/12/16 Mon Sínaxis Yperagías Theotókou Marías / Agios Stefanos / Boxing Day
31/12/16 Sat Paramoní Protochroniás (New Year's Eve)
Sources:
http://www.imk.gr/eng/opk/opk08.htm
http://goinggreek.info/dls_files/ggi-paska-calc.xls
-
Greek Holiday Calculator produces a list of currently recognised public holidays / feast days and notable events for any year.
By default it shows dates for current year, to view dates for another year enter year in cell A1.
Created in LibreOffice Calc, should open and function in MS Excel and OpenOffice. Looks to be reasonably accurate but offered "as is". Download available below in .xlsx (Excel 2007-2016), .xls (Excel 97-2003) and .ods (LibreOffice/OpenOffice Calc) formats.
(http://goinggreek.info/gallery/1_11_01_16_4_15_31.png) (http://goinggreek.info/gallery/1_11_01_16_3_56_23.png)
Edit: download files amended to work in Excel
-
Greek Holiday Calculator produces a list of currently recognised public holidays / feast days and notable events for any year.
By default it shows dates for current year, to view dates for another year enter year in cell A1.
Created in LibreOffice Calc, should open and function in MS Excel and OpenOffice. Looks to be reasonably accurate but offered "as is". Download available below.
(http://goinggreek.info/gallery/1_11_01_16_4_15_31.png) (http://goinggreek.info/gallery/1_11_01_16_3_56_23.png)
I'm using Microsoft Excel 2007 and all I get in the fields is #NAME?
Am I doing something wrong?
-
I'm using Microsoft Excel 2007 and all I get in the fields is #NAME?Am I doing something wrong?
Probably not, but it should open OK in Excel 2007. Can it (Excel 2007) handle .xls and/or .odt .ods files?
-
Can you (/anyone) try this .xls version
Edit: download removed, incompatible with Excel
-
Can you (/anyone) try this .xls version
Get the same as I did previously. I can load other .xls files but haven't been able to find a .odt file to try yet.
-
Maik, your formulas point at E, H, G etc, but there's no content there when opened in Excel
(ignore above, have just unprotected cells)
I'm getting the same "#NAME?" in A3 - D45
-
(F49) DAYSINYEAR is not a function in Excel
Use =MOD(YEAR(F50),4) perhaps?
-
(F49) DAYSINYEAR is not a function in Excel
Yep, that could be it :iroll:
Use =MOD(YEAR(F50),4) perhaps?
Thanks, I'll have a play with that :)
-
I cleared F49, and spreadsheet then functions - except of course, I expect there's no Feb 29 check?
-
MOD works... well, for me, anyway... just going to upload it somewhere
-
Version using MOD
-
Thanks, now works for me in Excel 2003
-
Working fine for me now as well.
-
Thanks, now works for me in Excel 2003
Working fine for me now as well.
:yahoo: Download files amended in this post (http://goinggreek.info/index.php?topic=2079.msg11156#msg11156), should work OK now. Thanks for your help, guys! :btu: :btu:
-
Karnavali days on Kef:
06/03/16 (Sunday): Poros 14:30
11/03/16 (Friday): Argostoli night parade 19:30
12/03/16 (Saturday): Argostoli 15:00
12/03/16 (Saturday): Lixouri night parade ?
13/03/16 (Sunday): Lixouri 15:00
Edit: updated with times
-
(http://goinggreek.info/gallery/1_24_02_16_1_15_05.jpeg)
Karnavali dance at Agrotoleschi, Agia Eirini this Saturday, 27/02/16 @ 20:00, admission 5€ including food
Skala Womens' Cultural Association holding a party at BBs on 27/02/16 starting 21:00, everyone invited
-
Poros karnavali: today, Sunday, 06/03/16 Poros plateia @ 14:30 (GMT ;))
(http://goinggreek.info/gallery/1_06_03_16_7_32_01.jpeg)
-
Maik you look very dapper enjoy the show !
-
Sorry your feeling under the weather mate. Get well soon Coco ! (Billy Smart sends his best.)
-
Independence Day parade in Argostoli main square tomorrow starts 12:00
-
Annual exhibition of local agricultural and traditional handicraft products to be held in Poros plateia Sunday, 31/07/16 starting 19:30.
-
Traditional dances festival in Skala school yard, Saturday, 16 July starting 20:30
Annual Ioannis Fokas 8.3 km 'fun run' :hmm: Sunday, 17 July starting Valeriano 18:30
-
Phew!! sooner them than me Good Luck!!!
-
A little less energetic... Peoples' Culture Week in Poros from Wednesday, 27 - Sunday, 31 July. Includes the annual traditional local products fayre in the square.
-
Festival of Agias Paraskevis in Troianata on Monday, 25 july starting at 20:00. Menu sounds good!
-
Sunday 31st August
Yianni Fokas Square on the main road, Valeriano (near Hionata & Katelios)
Starts at 9pm-ish
Traditional dancing
Food and drink
Free entry
-
August or July?
-
July - it's happening tomorrow night - the Yannis Fokas group will be in costumes from the island of Naxos and dancing five dances from Naxos
-
TRANSFIGURATION OF THE SAVIOUR, 05/08/16 @ 19:30 in Poros
Not sure what'll be going on but usually a procession through the town
-
Commemoration of the villagers executed by the Nazis, Sunday, 07/08 in Arginia @ 11:00
Troianata festival,Wednesday, 10/08 @ 21:00
-
Festival in Poros square Sat. 6 August, beginning 9 pm-ish. Come enjoy the music, dancing, souvlakia, crowds, and fun!
-
Quite a few villages celebrating around this time. In addition to the 'big two' festivals in Markopoulo and the Omala Valley there's also:
14/08/16: Simotata: Church of the Virgin Mary @ 20:00
14/08/16: Aykona: Central Square @ 21:30
15/08/16: Havriata: village @ 21:00
16/08/16: Raftopouleio, Mesovouni @ 21:00 (music &, poetry, admission 8€)
17/08/16: Sami Elementary School @ 21:00 (music &, poetry, admission 8€)
17/08/16: Dilinata: Lamias courtyard @ 21:00
Probably also celebrations in Skala square to celebrate Agios Gerasimos
-
Annual village pitta (pie) festival, Tzannata plateia, (late) evening of Friday, 19 August. Expect the usual: music, dancing, wine... and pitta.
-
Μια Γέφυρα τραγούδια - songs on the de Bosset bridge, Friday, 19 August from 21:30
-
Festival of Αϊγιάννη (Agios Yiannis), Ratzakli plateia, Sunday, 28/08/16 starting 20:30
-
24th Telemakeios Road Race, starts Skala main square @ 18:00 on Saturday, 10/09/16, finishes Poros main square @......
More info on 26710 25600