{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tabelle1","Tabelle2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[16,6,16,8],[9,6,9,8],[17,6,17,8],[18,6,18,8],[19,6,19,8],[51,9,51,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[15,6,15,8],[45,9,45,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[44,9,44,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[32,9,32,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[14,9,14,10],[20,9,20,10],[1,11,1,13],[2,11,2,13],[3,9,3,10],[1,9,1,10],[15,9,15,10],[16,9,16,10],[17,9,17,10],[18,9,18,10],[19,9,19,10]]}
[]
[null,null,null,null,null,"Jahreszahl","Aus Tabelle kopiertes Datum","Jahreszahl von Dat. G3","Wenn G3 leer = 0, sonst wenn Unter- schied F3 zu H3 =1","Formel in L2:N2 →",null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(L3,4)), \"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(F3,4)&\" ändern\", \"Folgende Tage werden automatisch abgezogen\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"2026",null,{"$f":"TEXT(G3,\"JJJJ\")","v":"1900"},{"$f":"IF(G3=0,0,IF(F3<>H3,1,0))","v":0},null,null,{"$f":"\"Feiertage in Berlin \"&TEXT(L5,\"JJJJ\")","v":"Feiertage in Berlin 2026"}]
[null,null,null,null,null,null,null,null,null,"Bedingte Formatierung in L4 →",null,"Datum","Wochentag","Feiertag - Frei - Urlaub - Krank"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-01-01",{"$f":"IF(L5=\"\",\"\",TEXT(L5,\"TTTT\"))","v":"Donnerstag"},"Neujahr"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-03-08","Sonntag","Internationaler Frauentag",null,null,null,null,null,null,null,null,null,null,null,null,"Frei"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-04-03","Freitag","Karfreitag",null,null,null,null,null,null,null,null,null,null,null,null,"Urlaub"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-04-06","Montag","Ostermontag",null,null,null,null,null,null,null,null,null,null,null,null,"Krank"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-05-01","Freitag","Tag der Arbeit"]
[null,null,null,null,null,null,"Meine Versuche",null,null,null,null,"2026-05-14","Donnerstag","Christi Himmelfahrt"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3)=0, \"Nicht gleich\", \"Gleich\")","v":"Nicht gleich"},null,null,null,null,"2026-05-25","Montag","Pfingstmontag"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3)<>F3,\"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,\"JJJJ\")&\" ändern\",\"Folgende Tage werden automatisch abgezogen\")","v":"Datum für einzelne abwesende Tage ins Jahr Feiertage in Berlin 2026 ändern"},null,null,null,null,"2026-10-03","Samstag","Tag der Deutschen Einheit"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3)<>RIGHT(YEAR(F3),4),\"Folgende Tage werden automatisch abgezogen\",\"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,\"JJJJ\")&\" ändern\")","v":"Folgende Tage werden automatisch abgezogen"},null,null,null,null,"2026-12-25","Freitag","1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3) = 0, \"Unterschied\",\"Kein Unterschied\")","v":"Unterschied"},null,null,null,null,"2026-12-26","Samstag","2. Weihnachtsfeiertag"]
[null,null,null,null,null,null,{"$f":"IF(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(TEXT(F3,\"jjjj\"),4), \"Unterschied\", \"Kein Unterschied\")","v":"Unterschied"},null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(F3,4)), \"Unterschiedliches Jahr vorhanden\", \"Alle Jahre gleich\")","v":"Alle Jahre gleich"},null,null,"Prüfbereich →",null,"2026-01-01","Donnerstag","Frei"]
[null,null,null,null,null,null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(F3,4)), \"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,4)&\" ändern\", \"Folgende Tage werden automatisch abgezogen\")","v":"Datum für einzelne abwesende Tage ins Jahr Feiertage in Berlin 2026 ändern"},null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(L3,4)), \"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,4)&\" ändern\", \"Folgende Tage werden automatisch abgezogen\")","v":"Folgende Tage werden automatisch abgezogen"},null,null,"Prüfbereich →",null,"2026-02-09","Montag","Krank"]
[null,null,null,null,null,{"$f":"TEXT(L19,\"JJJJ\")","v":"2027"},{"$f":"IF(RIGHT(L15:L55,4)<>F3,\"Unterschied\",\"Kein Unterschied\")","v":"Unterschied"},null,null,"Prüfbereich →",null,"2027-02-10","Mittwoch","Krank"]
[null,null,null,null,null,null,{"$f":"IF(RIGHT(TEXT(L15:L55,\"JJJJ\"),4)<>RIGHT(TEXT(F3,\"JJJJ\"),4),\"Nicht gleich\",\"Gleich\")","v":"Nicht gleich"},null,null,"Prüfbereich →",null,"2026-02-11","Mittwoch","Krank"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-02-12","Donnerstag","Krank"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-02-13","Freitag","Krank"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-03","Montag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2028-08-04","Freitag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-05","Mittwoch","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-06","Donnerstag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-07","Freitag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2027-09-08","Mittwoch"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-09-09","Mittwoch"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-09-10","Donnerstag","Frei"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2025-10-14","Dienstag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-10-15","Donnerstag"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"                Endemarke ---------->",null,"#"]

{"sheet":"Tabelle2","index":1,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[14,9,14,10],[1,9,1,10],[1,11,1,13],[2,5,3,5],[2,11,2,13],[3,9,3,10],[9,6,9,8],[10,6,10,8],[11,6,11,8],[12,6,12,8],[13,6,13,8],[14,6,14,8],[21,9,21,10],[15,6,15,8],[15,9,15,10],[16,6,16,8],[16,9,16,10],[17,6,17,8],[17,9,17,10],[18,6,18,8],[18,9,18,10],[19,6,19,8],[19,9,19,10],[20,9,20,10],[33,9,33,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[45,9,45,10],[34,9,34,10],[35,9,35,10],[36,9,36,10],[37,9,37,10],[38,9,38,10],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[44,9,44,10],[52,9,52,10],[53,9,53,10],[54,9,54,10],[46,9,46,10],[47,9,47,10],[48,9,48,10],[49,9,49,10],[50,9,50,10],[51,9,51,10]]}
[]
[null,null,null,null,null,"Datum",null,null,null,"Formel in L2:N2 →",null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(L3,4)), \"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(F3,4)&\" ändern\", \"Folgende Tage werden automatisch abgezogen\")","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,"2026-01-01",null,null,null,null,null,{"$f":"\"Feiertage in Berlin \"&TEXT(L5,\"JJJJ\")","v":"Feiertage in Berlin 2026"}]
[null,null,null,null,null,null,null,null,null,"Bedingte Formatierung in L4 →",null,"Datum","Wochentag","Feiertag - Frei - Urlaub - Krank"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-01-01",{"$f":"IF(L5=\"\",\"\",TEXT(L5,\"TTTT\"))","v":"Donnerstag"},"Neujahr"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-03-08","Sonntag","Internationaler Frauentag",null,null,null,null,null,null,null,null,null,null,null,null,"Frei"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-04-03","Freitag","Karfreitag",null,null,null,null,null,null,null,null,null,null,null,null,"Urlaub"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-04-06","Montag","Ostermontag",null,null,null,null,null,null,null,null,null,null,null,null,"Krank"]
[null,null,null,null,null,null,null,null,null,null,null,"2026-05-01","Freitag","Tag der Arbeit"]
[null,null,null,null,null,null,"Meine Versuche",null,null,null,null,"2026-05-14","Donnerstag","Christi Himmelfahrt"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3)=0, \"Nicht gleich\", \"Gleich\")","v":"Gleich"},null,null,null,null,"2026-05-25","Montag","Pfingstmontag"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3)<>F3,\"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,\"JJJJ\")&\" ändern\",\"Folgende Tage werden automatisch abgezogen\")","v":"Datum für einzelne abwesende Tage ins Jahr Feiertage in Berlin 2026 ändern"},null,null,null,null,"2026-10-03","Samstag","Tag der Deutschen Einheit"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3)<>RIGHT(YEAR(F3),4),\"Folgende Tage werden automatisch abgezogen\",\"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,\"JJJJ\")&\" ändern\")","v":"Folgende Tage werden automatisch abgezogen"},null,null,null,null,"2026-12-25","Freitag","1. Weihnachtsfeiertag"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(L15:L55,F3) = 0, \"Unterschied\",\"Kein Unterschied\")","v":"Kein Unterschied"},null,null,null,null,"2026-12-26","Samstag","2. Weihnachtsfeiertag"]
[null,null,null,null,null,null,{"$f":"IF(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(TEXT(F3,\"jjjj\"),4), \"Unterschied\", \"Kein Unterschied\")","v":"Unterschied"},null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(F3,4)), \"Unterschiedliches Jahr vorhanden\", \"Alle Jahre gleich\")","v":"Unterschiedliches Jahr vorhanden"},null,null,"Prüfbereich →",null,"2026-01-01","Donnerstag","Frei"]
[null,null,null,null,null,null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(F3,4)), \"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,4)&\" ändern\", \"Folgende Tage werden automatisch abgezogen\")","v":"Datum für einzelne abwesende Tage ins Jahr Feiertage in Berlin 2026 ändern"},null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,{"$f":"IF(OR(RIGHT(TEXT(L15:L55,\"jjjj\"),4)<>RIGHT(L3,4)), \"Datum für einzelne abwesende Tage ins Jahr \"&TEXT(L3,4)&\" ändern\", \"Folgende Tage werden automatisch abgezogen\")","v":"Folgende Tage werden automatisch abgezogen"},null,null,"Prüfbereich →",null,"2026-02-09","Montag","Krank"]
[null,null,null,null,null,{"$f":"TEXT(L19,\"JJJJ\")","v":"2027"},{"$f":"IF(RIGHT(L15:L55,4)<>F3,\"Unterschied\",\"Kein Unterschied\")","v":"Unterschied"},null,null,"Prüfbereich →",null,"2027-02-10","Mittwoch","Krank"]
[null,null,null,null,null,null,{"$f":"IF(RIGHT(TEXT(L15:L55,\"JJJJ\"),4)<>RIGHT(TEXT(F3,\"JJJJ\"),4),\"Nicht gleich\",\"Gleich\")","v":"Gleich"},null,null,"Prüfbereich →",null,"2026-02-11","Mittwoch","Krank"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-02-12","Donnerstag","Krank"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-02-13","Freitag","Krank"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-03","Montag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2028-08-04","Freitag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-05","Mittwoch","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-06","Donnerstag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-08-07","Freitag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2027-09-08","Mittwoch"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-09-09","Mittwoch"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-09-10","Donnerstag","Frei"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2025-10-14","Dienstag","Urlaub"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,"2026-10-15","Donnerstag"]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"Prüfbereich →",null,null,""]
[null,null,null,null,null,null,null,null,null,"                Endemarke ---------->",null,"#"]