{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Übersicht","Urlaubsliste","Ferien","Input","Feiertagsrechner"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":1,"defined_names":30,"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":"Übersicht","index":0,"n_rows":33,"n_cols":373,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,339,4,369],[0,4,4,34],[0,35,4,62],[0,64,4,94],[0,95,4,124],[0,125,4,155],[0,156,4,185],[0,186,4,216],[0,217,4,247],[0,248,4,277],[0,278,4,308],[0,309,4,338],[5,217,7,247],[5,248,7,277],[5,278,7,308],[5,309,7,338],[5,339,7,369],[8,2,8,3],[10,1,11,1],[10,2,11,2],[10,3,11,3],[5,186,7,216],[5,4,7,34],[5,35,7,62],[5,64,7,94],[5,95,7,124],[5,125,7,155],[5,156,7,185]]}
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"B9","v":"2025-01-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(E6,0)+1","v":"2025-02-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(AJ6,0)+1","v":"2025-03-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(BM6,0)+1","v":"2025-04-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(CR6,0)+1","v":"2025-05-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(DV6,0)+1","v":"2025-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(FA6,0)+1","v":"2025-07-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(GE6,0)+1","v":"2025-08-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(HJ6,0)+1","v":"2025-09-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(IO6,0)+1","v":"2025-10-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(JS6,0)+1","v":"2025-11-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"EOMONTH(KX6,0)+1","v":"2025-12-01"}]
[]
[]
[null,"2025-01-01","Kalender- woche",null,{"$f":"_xlfn.ISOWEEKNUM(E11)","v":1},{"$f":"IF(WEEKDAY(F11,2)=1,_xlfn.ISOWEEKNUM(F11),\"\")","v":""},{"$f":"IF(WEEKDAY(G11,2)=1,_xlfn.ISOWEEKNUM(G11),\"\")","v":""},"","",2,"","","","","","",3,"","","","","","",4,"","","","","","",5,"","","","","","",6,"","","","","","",7,"","","","","","",8,"","","","","","",9,"","","","",null,"","",10,"","","","",{"$f":"IF(WEEKDAY(BT11,2)=1,_xlfn.ISOWEEKNUM(BT11),\"\")","v":""},"",11,"","","","","","",12,"","","","","","",13,"","","","","","",14,"","","","","","",15,"","","","","","",16,"","","","","","",17,"","","","","","",18,"","","","","","",19,"","","","","",{"$f":"IF(WEEKDAY(EF11,2)=1,_xlfn.ISOWEEKNUM(EF11),\"\")","v":""},20,"","","","","","",21,"","","","","","",22,"","","","","",{"$f":"IF(WEEKDAY(FA11,2)=1,_xlfn.ISOWEEKNUM(FA11),\"\")","v":""},23,"","","","","","",24,"","","","","","",25,"","","","","","",26,"","","","","","",27,{"$f":"IF(WEEKDAY(GE11,2)=1,_xlfn.ISOWEEKNUM(GE11),\"\")","v":""},"","","","","",28,"","","","","","",{"$f":"IF(WEEKDAY(GR11,2)=1,_xlfn.ISOWEEKNUM(GR11),\"\")","v":29},"","","","","","",30,"","","","","","",31,"","","",{"$f":"IF(WEEKDAY(HJ11,2)=1,_xlfn.ISOWEEKNUM(HJ11),\"\")","v":""},"","",32,"","","","","","",33,"","","","","","",34,"","","","","","",35,"","","","","","",36,"","","","","","",37,"","","","","","",38,{"$f":"IF(WEEKDAY(JD11,2)=1,_xlfn.ISOWEEKNUM(JD11),\"\")","v":""},"","","","","",39,"","","","","","",40,"","","","","","",41,"","","","","","",42,"","","","","","",43,"","","","","","",44,"","","","","","",45,"","","","","","",46,"","","","","","",47,"",{"$f":"IF(WEEKDAY(LP11,2)=1,_xlfn.ISOWEEKNUM(LP11),\"\")","v":""},"","","","",48,"","","","","","",49,"","","","","","",50,"","","","","","",51,"","","","","","",52,"","","","","","",1,"",""]
[null,null,null,null,{"$f":"IF(WEEKDAY(E11,2)>5,1,0)+IF(ISNA(VLOOKUP(E11,Feiertage,1,FALSE)),0,1)","v":1},{"$f":"IF(WEEKDAY(F11,2)>5,1,0)+IF(ISNA(VLOOKUP(F11,Feiertage,1,FALSE)),0,1)","v":0},{"$f":"IF(WEEKDAY(G11,2)>5,1,0)+IF(ISNA(VLOOKUP(G11,Feiertage,1,FALSE)),0,1)","v":0},1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,null,1,1,0,0,0,0,0,{"$f":"IF(WEEKDAY(BT11,2)>5,1,0)+IF(ISNA(VLOOKUP(BT11,Feiertage,1,FALSE)),0,1)","v":1},1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,1,1,2,1,0,0,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,{"$f":"IF(WEEKDAY(EF11,2)>5,1,0)+IF(ISNA(VLOOKUP(EF11,Feiertage,1,FALSE)),0,1)","v":1},0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,2,1,0,0,0,0,1,1,0,0,0,1,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,{"$f":"IF(WEEKDAY(GR11,2)>5,1,0)+IF(ISNA(VLOOKUP(GR11,Feiertage,1,FALSE)),0,1)","v":0},0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,1,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,{"$f":"IF(WEEKDAY(JD11,2)>5,1,0)+IF(ISNA(VLOOKUP(JD11,Feiertage,1,FALSE)),0,1)","v":0},0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,1,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,2,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,{"$f":"IF(WEEKDAY(LP11,2)>5,1,0)+IF(ISNA(VLOOKUP(LP11,Feiertage,1,FALSE)),0,1)","v":0},0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,0,0,1,1,0,0,0,1,1,1,1,0,0,0]
[null,"Mitarbeiter","Urlaub","Rest",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(E6,0)),E6)","v":"2025-01-01"},"2025-01-02","2025-01-03","2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28","2025-01-29","2025-01-30","2025-01-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(AJ6,0)),AJ6)","v":"2025-02-01"},"2025-02-02","2025-02-03","2025-02-04","2025-02-05","2025-02-06","2025-02-07","2025-02-08","2025-02-09","2025-02-10","2025-02-11","2025-02-12","2025-02-13","2025-02-14","2025-02-15","2025-02-16","2025-02-17","2025-02-18","2025-02-19","2025-02-20","2025-02-21","2025-02-22","2025-02-23","2025-02-24","2025-02-25","2025-02-26","2025-02-27","2025-02-28",null,{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(BM6,0)),BM6)","v":"2025-03-01"},"2025-03-02","2025-03-03","2025-03-04","2025-03-05","2025-03-06","2025-03-07","2025-03-08","2025-03-09","2025-03-10","2025-03-11","2025-03-12","2025-03-13","2025-03-14","2025-03-15","2025-03-16","2025-03-17","2025-03-18","2025-03-19","2025-03-20","2025-03-21","2025-03-22","2025-03-23","2025-03-24","2025-03-25","2025-03-26","2025-03-27","2025-03-28","2025-03-29","2025-03-30","2025-03-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(CR6,0)),CR6)","v":"2025-04-01"},"2025-04-02","2025-04-03","2025-04-04","2025-04-05","2025-04-06","2025-04-07","2025-04-08","2025-04-09","2025-04-10","2025-04-11","2025-04-12","2025-04-13","2025-04-14","2025-04-15","2025-04-16","2025-04-17","2025-04-18","2025-04-19","2025-04-20","2025-04-21","2025-04-22","2025-04-23","2025-04-24","2025-04-25","2025-04-26","2025-04-27","2025-04-28","2025-04-29","2025-04-30",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(DV6,0)),DV6)","v":"2025-05-01"},"2025-05-02","2025-05-03","2025-05-04","2025-05-05","2025-05-06","2025-05-07","2025-05-08","2025-05-09","2025-05-10","2025-05-11","2025-05-12","2025-05-13","2025-05-14","2025-05-15","2025-05-16","2025-05-17","2025-05-18","2025-05-19","2025-05-20","2025-05-21","2025-05-22","2025-05-23","2025-05-24","2025-05-25","2025-05-26","2025-05-27","2025-05-28","2025-05-29","2025-05-30","2025-05-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(FA6,0)),FA6)","v":"2025-06-01"},"2025-06-02","2025-06-03","2025-06-04","2025-06-05","2025-06-06","2025-06-07","2025-06-08","2025-06-09","2025-06-10","2025-06-11","2025-06-12","2025-06-13","2025-06-14","2025-06-15","2025-06-16","2025-06-17","2025-06-18","2025-06-19","2025-06-20","2025-06-21","2025-06-22","2025-06-23","2025-06-24","2025-06-25","2025-06-26","2025-06-27","2025-06-28","2025-06-29","2025-06-30",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(GE6,0)),GE6)","v":"2025-07-01"},"2025-07-02","2025-07-03","2025-07-04","2025-07-05","2025-07-06","2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13","2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20","2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27","2025-07-28","2025-07-29","2025-07-30","2025-07-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(HJ6,0)),HJ6)","v":"2025-08-01"},"2025-08-02","2025-08-03","2025-08-04","2025-08-05","2025-08-06","2025-08-07","2025-08-08","2025-08-09","2025-08-10","2025-08-11","2025-08-12","2025-08-13","2025-08-14","2025-08-15","2025-08-16","2025-08-17","2025-08-18","2025-08-19","2025-08-20","2025-08-21","2025-08-22","2025-08-23","2025-08-24","2025-08-25","2025-08-26","2025-08-27","2025-08-28","2025-08-29","2025-08-30","2025-08-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(IO6,0)),IO6)","v":"2025-09-01"},"2025-09-02","2025-09-03","2025-09-04","2025-09-05","2025-09-06","2025-09-07","2025-09-08","2025-09-09","2025-09-10","2025-09-11","2025-09-12","2025-09-13","2025-09-14","2025-09-15","2025-09-16","2025-09-17","2025-09-18","2025-09-19","2025-09-20","2025-09-21","2025-09-22","2025-09-23","2025-09-24","2025-09-25","2025-09-26","2025-09-27","2025-09-28","2025-09-29","2025-09-30",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(JS6,0)),JS6)","v":"2025-10-01"},"2025-10-02","2025-10-03","2025-10-04","2025-10-05","2025-10-06","2025-10-07","2025-10-08","2025-10-09","2025-10-10","2025-10-11","2025-10-12","2025-10-13","2025-10-14","2025-10-15","2025-10-16","2025-10-17","2025-10-18","2025-10-19","2025-10-20","2025-10-21","2025-10-22","2025-10-23","2025-10-24","2025-10-25","2025-10-26","2025-10-27","2025-10-28","2025-10-29","2025-10-30","2025-10-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(KX6,0)),KX6)","v":"2025-11-01"},"2025-11-02","2025-11-03","2025-11-04","2025-11-05","2025-11-06","2025-11-07","2025-11-08","2025-11-09","2025-11-10","2025-11-11","2025-11-12","2025-11-13","2025-11-14","2025-11-15","2025-11-16","2025-11-17","2025-11-18","2025-11-19","2025-11-20","2025-11-21","2025-11-22","2025-11-23","2025-11-24","2025-11-25","2025-11-26","2025-11-27","2025-11-28","2025-11-29","2025-11-30",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(MB6,0)),MB6)","v":"2025-12-01"},"2025-12-02","2025-12-03","2025-12-04","2025-12-05","2025-12-06","2025-12-07","2025-12-08","2025-12-09","2025-12-10","2025-12-11","2025-12-12","2025-12-13","2025-12-14","2025-12-15","2025-12-16","2025-12-17","2025-12-18","2025-12-19","2025-12-20","2025-12-21","2025-12-22","2025-12-23","2025-12-24","2025-12-25","2025-12-26","2025-12-27","2025-12-28","2025-12-29","2025-12-30","2025-12-31"]
[null,null,null,null,{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(E6,0)),E6)","v":"2025-01-01"},"2025-01-02","2025-01-03","2025-01-04","2025-01-05","2025-01-06","2025-01-07","2025-01-08","2025-01-09","2025-01-10","2025-01-11","2025-01-12","2025-01-13","2025-01-14","2025-01-15","2025-01-16","2025-01-17","2025-01-18","2025-01-19","2025-01-20","2025-01-21","2025-01-22","2025-01-23","2025-01-24","2025-01-25","2025-01-26","2025-01-27","2025-01-28","2025-01-29","2025-01-30","2025-01-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(AJ6,0)),AJ6)","v":"2025-02-01"},"2025-02-02","2025-02-03","2025-02-04","2025-02-05","2025-02-06","2025-02-07","2025-02-08","2025-02-09","2025-02-10","2025-02-11","2025-02-12","2025-02-13","2025-02-14","2025-02-15","2025-02-16","2025-02-17","2025-02-18","2025-02-19","2025-02-20","2025-02-21","2025-02-22","2025-02-23","2025-02-24","2025-02-25","2025-02-26","2025-02-27","2025-02-28",null,{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(BM6,0)),BM6)","v":"2025-03-01"},"2025-03-02","2025-03-03","2025-03-04","2025-03-05","2025-03-06","2025-03-07","2025-03-08","2025-03-09","2025-03-10","2025-03-11","2025-03-12","2025-03-13","2025-03-14","2025-03-15","2025-03-16","2025-03-17","2025-03-18","2025-03-19","2025-03-20","2025-03-21","2025-03-22","2025-03-23","2025-03-24","2025-03-25","2025-03-26","2025-03-27","2025-03-28","2025-03-29","2025-03-30","2025-03-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(CR6,0)),CR6)","v":"2025-04-01"},"2025-04-02","2025-04-03","2025-04-04","2025-04-05","2025-04-06","2025-04-07","2025-04-08","2025-04-09","2025-04-10","2025-04-11","2025-04-12","2025-04-13","2025-04-14","2025-04-15","2025-04-16","2025-04-17","2025-04-18","2025-04-19","2025-04-20","2025-04-21","2025-04-22","2025-04-23","2025-04-24","2025-04-25","2025-04-26","2025-04-27","2025-04-28","2025-04-29","2025-04-30",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(DV6,0)),DV6)","v":"2025-05-01"},"2025-05-02","2025-05-03","2025-05-04","2025-05-05","2025-05-06","2025-05-07","2025-05-08","2025-05-09","2025-05-10","2025-05-11","2025-05-12","2025-05-13","2025-05-14","2025-05-15","2025-05-16","2025-05-17","2025-05-18","2025-05-19","2025-05-20","2025-05-21","2025-05-22","2025-05-23","2025-05-24","2025-05-25","2025-05-26","2025-05-27","2025-05-28","2025-05-29","2025-05-30","2025-05-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(FA6,0)),FA6)","v":"2025-06-01"},"2025-06-02","2025-06-03","2025-06-04","2025-06-05","2025-06-06","2025-06-07","2025-06-08","2025-06-09","2025-06-10","2025-06-11","2025-06-12","2025-06-13","2025-06-14","2025-06-15","2025-06-16","2025-06-17","2025-06-18","2025-06-19","2025-06-20","2025-06-21","2025-06-22","2025-06-23","2025-06-24","2025-06-25","2025-06-26","2025-06-27","2025-06-28","2025-06-29","2025-06-30",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(GE6,0)),GE6)","v":"2025-07-01"},"2025-07-02","2025-07-03","2025-07-04","2025-07-05","2025-07-06","2025-07-07","2025-07-08","2025-07-09","2025-07-10","2025-07-11","2025-07-12","2025-07-13","2025-07-14","2025-07-15","2025-07-16","2025-07-17","2025-07-18","2025-07-19","2025-07-20","2025-07-21","2025-07-22","2025-07-23","2025-07-24","2025-07-25","2025-07-26","2025-07-27","2025-07-28","2025-07-29","2025-07-30","2025-07-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(HJ6,0)),HJ6)","v":"2025-08-01"},"2025-08-02","2025-08-03","2025-08-04","2025-08-05","2025-08-06","2025-08-07","2025-08-08","2025-08-09","2025-08-10","2025-08-11","2025-08-12","2025-08-13","2025-08-14","2025-08-15","2025-08-16","2025-08-17","2025-08-18","2025-08-19","2025-08-20","2025-08-21","2025-08-22","2025-08-23","2025-08-24","2025-08-25","2025-08-26","2025-08-27","2025-08-28","2025-08-29","2025-08-30","2025-08-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(IO6,0)),IO6)","v":"2025-09-01"},"2025-09-02","2025-09-03","2025-09-04","2025-09-05","2025-09-06","2025-09-07","2025-09-08","2025-09-09","2025-09-10","2025-09-11","2025-09-12","2025-09-13","2025-09-14","2025-09-15","2025-09-16","2025-09-17","2025-09-18","2025-09-19","2025-09-20","2025-09-21","2025-09-22","2025-09-23","2025-09-24","2025-09-25","2025-09-26","2025-09-27","2025-09-28","2025-09-29","2025-09-30",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(JS6,0)),JS6)","v":"2025-10-01"},"2025-10-02","2025-10-03","2025-10-04","2025-10-05","2025-10-06","2025-10-07","2025-10-08","2025-10-09","2025-10-10","2025-10-11","2025-10-12","2025-10-13","2025-10-14","2025-10-15","2025-10-16","2025-10-17","2025-10-18","2025-10-19","2025-10-20","2025-10-21","2025-10-22","2025-10-23","2025-10-24","2025-10-25","2025-10-26","2025-10-27","2025-10-28","2025-10-29","2025-10-30","2025-10-31",{"$f":"_xlfn.SEQUENCE(1,DAY(EOMONTH(KX6,0)),KX6)","v":"2025-11-01"},"2025-11-02","2025-11-03","2025-11-04","2025-11-05","2025-11-06","2025-11-07","2025-11-08","2025-11-09","2025-11-10","2025-11-11","2025-11-12","2025-11-13","2025-11-14","2025-11-15","2025-11-16","2025-11-17","2025-11-18","2025-11-19","2025-11-20","2025-11-21","2025-11-22","2025-11-23","2025-11-24","2025-11-25","2025-11-26","2025-11-27","2025-11-28","2025-11-29","2025-11-30"]
[null,"Spalte1","Spalte2","Spalte3","Spalte5","Spalte6","Spalte7","Spalte8","Spalte9","Spalte10","Spalte11","Spalte12","Spalte13","Spalte14","Spalte15","Spalte16","Spalte17","Spalte18","Spalte19","Spalte20","Spalte21","Spalte22","Spalte23","Spalte24","Spalte25","Spalte26","Spalte27","Spalte28","Spalte29","Spalte30","Spalte31","Spalte32","Spalte33","Spalte34","Spalte35","Spalte36","Spalte37","Spalte38","Spalte39","Spalte40","Spalte41","Spalte42","Spalte43","Spalte44","Spalte45","Spalte46","Spalte47","Spalte48","Spalte49","Spalte50","Spalte51","Spalte52","Spalte53","Spalte54","Spalte55","Spalte56","Spalte57","Spalte58","Spalte59","Spalte60","Spalte61","Spalte62","Spalte63","Spalte632","Spalte64","Spalte65","Spalte66","Spalte67","Spalte68","Spalte69","Spalte70","Spalte71","Spalte72","Spalte73","Spalte74","Spalte75","Spalte76","Spalte77","Spalte78","Spalte79","Spalte80","Spalte81","Spalte82","Spalte83","Spalte84","Spalte85","Spalte86","Spalte87","Spalte88","Spalte89","Spalte90","Spalte91","Spalte92","Spalte93","Spalte94","Spalte95","Spalte96","Spalte97","Spalte98","Spalte99","Spalte100","Spalte101","Spalte102","Spalte103","Spalte104","Spalte105","Spalte106","Spalte107","Spalte108","Spalte109","Spalte110","Spalte111","Spalte112","Spalte113","Spalte114","Spalte115","Spalte116","Spalte117","Spalte118","Spalte119","Spalte120","Spalte121","Spalte122","Spalte123","Spalte124","Spalte125","Spalte126","Spalte127","Spalte128","Spalte129","Spalte130","Spalte131","Spalte132","Spalte133","Spalte134","Spalte135","Spalte136","Spalte137","Spalte138","Spalte139","Spalte140","Spalte141","Spalte142","Spalte143","Spalte144","Spalte145","Spalte146","Spalte147","Spalte148","Spalte149","Spalte150","Spalte151","Spalte152","Spalte153","Spalte154","Spalte155","Spalte156","Spalte157","Spalte158","Spalte159","Spalte160","Spalte161","Spalte162","Spalte163","Spalte164","Spalte165","Spalte166","Spalte167","Spalte168","Spalte169","Spalte170","Spalte171","Spalte172","Spalte173","Spalte174","Spalte175","Spalte176","Spalte177","Spalte178","Spalte179","Spalte180","Spalte181","Spalte182","Spalte183","Spalte184","Spalte185","Spalte186","Spalte187","Spalte188","Spalte189","Spalte190","Spalte191","Spalte192","Spalte193","Spalte194","Spalte195","Spalte196","Spalte197","Spalte198","Spalte199","Spalte200","Spalte201","Spalte202","Spalte203","Spalte204","Spalte205","Spalte206","Spalte207","Spalte208","Spalte209","Spalte210","Spalte211","Spalte212","Spalte213","Spalte214","Spalte215","Spalte216","Spalte217","Spalte218","Spalte219","Spalte220","Spalte221","Spalte222","Spalte223","Spalte224","Spalte225","Spalte226","Spalte227","Spalte228","Spalte229","Spalte230","Spalte231","Spalte232","Spalte233","Spalte234","Spalte235","Spalte236","Spalte237","Spalte238","Spalte239","Spalte240","Spalte241","Spalte242","Spalte243","Spalte244","Spalte245","Spalte246","Spalte247","Spalte248","Spalte249","Spalte250","Spalte251","Spalte252","Spalte253","Spalte254","Spalte255","Spalte256","Spalte257","Spalte258","Spalte259","Spalte260","Spalte261","Spalte262","Spalte263","Spalte264","Spalte265","Spalte266","Spalte267","Spalte268","Spalte269","Spalte270","Spalte271","Spalte272","Spalte273","Spalte274","Spalte275","Spalte276","Spalte277","Spalte278","Spalte279","Spalte280","Spalte281","Spalte282","Spalte283","Spalte284","Spalte285","Spalte286","Spalte287","Spalte288","Spalte289","Spalte290","Spalte291","Spalte292","Spalte293","Spalte294","Spalte295","Spalte296","Spalte297","Spalte298","Spalte299","Spalte300","Spalte301","Spalte302","Spalte303","Spalte304","Spalte305","Spalte306","Spalte307","Spalte308","Spalte309","Spalte310","Spalte311","Spalte312","Spalte313","Spalte314","Spalte315","Spalte316","Spalte317","Spalte318","Spalte319","Spalte320","Spalte321","Spalte322","Spalte323","Spalte324","Spalte325","Spalte326","Spalte327","Spalte328","Spalte329","Spalte330","Spalte331","Spalte332","Spalte333","Spalte334","Spalte335","Spalte336","Spalte337","Spalte338","Spalte4","Spalte339","Spalte340","Spalte341","Spalte342","Spalte343","Spalte344","Spalte345","Spalte346","Spalte347","Spalte348","Spalte349","Spalte350","Spalte351","Spalte352","Spalte353","Spalte354","Spalte355","Spalte356","Spalte357","Spalte358","Spalte359","Spalte360","Spalte361","Spalte362","Spalte363","Spalte364","Spalte365","Spalte366","Spalte367","Spalte368"]
[null,"AA",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"URLAUB"]
[null,"BB",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FZ"]
[null,"CC",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":26},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"U","U","U","U",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KRANK"]
[null,"DD",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"EE",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"FF",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"GG",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"HH",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"II",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"JJ",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"KK",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"LL",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"MM",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"NN",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"OO",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,"PP",30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,null,30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,null,30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,null,30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]
[null,null,30,{"$f":"Tabelle58[[#This Row],[Spalte2]]-COUNTIF(Tabelle58[[#This Row],[Spalte5]:[Spalte368]],\"U\")","v":30}]

{"sheet":"Urlaubsliste","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[null,"VON","BIS","U/FZ/K","TAGE"]
["AA","2025-01-01","2025-01-17","U",{"$f":"NETWORKDAYS($B2,$C2,Input!$E$3:$E$35)","v":12}]
["BB","2025-01-01","2025-01-01","U",{"$f":"NETWORKDAYS($B3,$C3,Input!$E$3:$E$35)","v":0},"TEST !"]
["BB","2025-01-07","2025-01-11","FZ",{"$f":"NETWORKDAYS($B4,$C4,Input!$E$3:$E$35)","v":4}]
["QQ","2025-01-07","2025-01-11","U",{"$f":"NETWORKDAYS($B5,$C5,Input!$E$3:$E$35)","v":4}]
["AA","2025-01-22","2025-01-25","U",{"$f":"NETWORKDAYS($B6,$C6,Input!$E$3:$E$35)","v":3}]
["FF","2025-01-12","2025-01-22","K",{"$f":"NETWORKDAYS($B7,$C7,Input!$E$3:$E$35)","v":8}]
["GG",null,null,null,{"$f":"NETWORKDAYS($B8,$C8,Input!$E$3:$E$35)","v":0}]
["HH","2025-01-06","2025-01-10","U",{"$f":"NETWORKDAYS($B9,$C9,Input!$E$3:$E$35)","v":5}]
["II",null,null,null,{"$f":"NETWORKDAYS($B10,$C10,Input!$E$3:$E$35)","v":0}]
["JJ",null,null,null,{"$f":"NETWORKDAYS($B11,$C11,Input!$E$3:$E$35)","v":0}]
["KK","2025-01-20","2025-01-20","U",{"$f":"NETWORKDAYS($B12,$C12,Input!$E$3:$E$35)","v":1}]
["LL",null,null,null,{"$f":"NETWORKDAYS($B13,$C13,Input!$E$3:$E$35)","v":0}]
["MM","2025-01-20","2025-01-24","U",{"$f":"NETWORKDAYS($B14,$C14,Input!$E$3:$E$35)","v":5}]
["NN",null,null,null,{"$f":"NETWORKDAYS($B15,$C15,Input!$E$3:$E$35)","v":0}]
["OO","2025-01-06","2025-01-10","U",{"$f":"NETWORKDAYS($B16,$C16,Input!$E$3:$E$35)","v":5}]
["PP",null,null,null,{"$f":"NETWORKDAYS($B17,$C17,Input!$E$3:$E$35)","v":0}]

{"sheet":"Ferien","index":2,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Ferien Saarland"]
[]
["Schuljahr 2024/25:",null,null,null,null,"Schuljahr 2027/28:"]
["Herbstferien: 14. Oktober 2024 – 25. Oktober 2024",null,null,null,null,"Herbstferien: 4. Oktober 2027 – 15. Oktober 2027"]
["Weihnachtsferien: 23. Dezember 2024 – 3. Januar 2025",null,null,null,null,"Weihnachtsferien: 20. Dezember 2027 – 31. Dezember 2027"]
["Fastnachtsferien: 24. Februar 2025 – 4. März 2025",null,null,null,null,"Fastnachtsferien: 21. Februar 2028 – 29. Februar 2028"]
["Osterferien: 14. April 2025 – 25. April 2025",null,null,null,null,"Osterferien: 12. April 2028 – 21. April 2028"]
["Sommerferien: 7. Juli 2025 – 14. August 2025",null,null,null,null,"Sommerferien: 3. Juli 2028 – 11. August 2028"]
[]
["Schuljahr 2025/26:",null,null,null,null,"Schuljahr 2028/29:"]
["Herbstferien: 13. Oktober 2025 – 24. Oktober 2025",null,null,null,null,"Herbstferien: 9. Oktober 2028 – 20. Oktober 2028"]
["Weihnachtsferien: 22. Dezember 2025 – 2. Januar 2026",null,null,null,null,"Weihnachtsferien: 20. Dezember 2028 – 2. Januar 2029"]
["Fastnachtsferien: 16. Februar 2026 – 20. Februar 2026",null,null,null,null,"Fastnachtsferien: 12. Februar 2029 – 16. Februar 2029"]
["Osterferien: 7. April 2026 – 17. April 2026",null,null,null,null,"Osterferien: 26. März 2029 – 6. April 2029"]
["Sommerferien: 29. Juni 2026 – 7. August 2026",null,null,null,null,"Pfingstferien: 22. Mai 2029 – 25. Mai 2029"]
[null,null,null,null,null,"Sommerferien: 16. Juli 2029 – 24. August 2029"]
["Schuljahr 2026/27:"]
["Herbstferien: 5. Oktober 2026 – 16. Oktober 2026",null,null,null,null,"Schuljahr 2029/30:  "]
["Weihnachtsferien: 21. Dezember 2026 – 31. Dezember 2026",null,null,null,null,"Herbstferien: 22. Oktober 2029 – 2. November 2029"]
["Fastnachtsferien: 8. Februar 2027 – 12. Februar 2027",null,null,null,null,"Weihnachtsferien: 21. Dezember 2029 – 4. Januar 2030"]
["Osterferien: 30. März 2027 – 9. April 2027",null,null,null,null,"Fastnachtsferien: 25. Februar 2030 – 5. März 2030"]
["Sommerferien: 28. Juni 2027 – 6. August 2027",null,null,null,null,"Osterferien: 15. April 2030 – 26. April 2030"]
[null,null,null,null,null,"Sommerferien 22. Juli 2030 – 30. August 2030"]
["*Ferien sind nur bis einschließlich der Sommerferien 2030 terminiert."]

{"sheet":"Input","index":3,"n_rows":72,"n_cols":17,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
["Startdatum",null,"Betriebsfrei",null,"Datum","Feiertag",null,"von","bis","Ferien",null,"Schuljahr 2024/25:",null,null,null,null,"Schuljahr 2027/28:"]
["2025-01-01",null,"2025-12-24",null,"2025-01-01","Neujahr",null,"2024-12-23","2025-01-03","Weihnachtsferien 2024",null,"Herbstferien: 14. Oktober 2024 – 25. Oktober 2024",null,null,null,null,"Herbstferien: 4. Oktober 2027 – 15. Oktober 2027"]
["2026-01-01",null,"2025-12-31",null,"2025-04-18","Karfreitag",null,"2025-02-24","2025-03-04","Winterferien 2025",null,"Weihnachtsferien: 23. Dezember 2024 – 3. Januar 2025",null,null,null,null,"Weihnachtsferien: 20. Dezember 2027 – 31. Dezember 2027"]
["2027-01-01",null,"2026-12-24",null,"2025-04-20","Ostersonntag",null,"2025-04-14","2025-04-25","Osterferien 2025",null,"Fastnachtsferien: 24. Februar 2025 – 4. März 2025",null,null,null,null,"Fastnachtsferien: 21. Februar 2028 – 29. Februar 2028"]
["2028-01-01",null,"2026-12-31",null,"2025-04-21","Ostermontag",null,"2025-07-07","2025-08-14","Sommerferien 2025",null,"Osterferien: 14. April 2025 – 25. April 2025",null,null,null,null,"Osterferien: 12. April 2028 – 21. April 2028"]
["2029-01-01",null,"2027-12-24",null,"2025-05-01","Tag der Arbeit",null,"2025-10-13","2025-10-24","Herbstferien 2025",null,"Sommerferien: 7. Juli 2025 – 14. August 2025",null,null,null,null,"Sommerferien: 3. Juli 2028 – 11. August 2028"]
["2030-01-01",null,"2027-12-31",null,"2025-05-29","Christi Himmelfahrt",null,"2025-12-22","2026-01-02","Weihnachtsferien 2025"]
[null,null,"2028-12-24",null,"2025-06-08","Pfingstsonntag",null,"2026-02-16","2026-02-20","Winterferien 2026",null,"Schuljahr 2025/26:",null,null,null,null,"Schuljahr 2028/29:"]
["Abwesenheit",null,"2028-12-31",null,"2025-06-09","Pfingstmontag",null,"2026-04-07","2026-04-17","Osterferien 2026",null,"Herbstferien: 13. Oktober 2025 – 24. Oktober 2025",null,null,null,null,"Herbstferien: 9. Oktober 2028 – 20. Oktober 2028"]
["U",null,"2029-12-24",null,"2025-06-19","Fronleichnam",null,"2026-06-29","2026-08-07","Sommerferien 2026",null,"Weihnachtsferien: 22. Dezember 2025 – 2. Januar 2026",null,null,null,null,"Weihnachtsferien: 20. Dezember 2028 – 2. Januar 2029"]
["FZ",null,"2029-12-31",null,"2025-08-15","Mariä Himmelfahrt",null,"2026-10-05","2026-10-16","Herbstferien 2026",null,"Fastnachtsferien: 16. Februar 2026 – 20. Februar 2026",null,null,null,null,"Fastnachtsferien: 12. Februar 2029 – 16. Februar 2029"]
[null,null,"2030-12-24",null,"2025-10-03","Tag der Deutschen Einheit",null,"2026-12-21","2026-12-31","Weihnachtsferien 2026",null,"Osterferien: 7. April 2026 – 17. April 2026",null,null,null,null,"Osterferien: 26. März 2029 – 6. April 2029"]
[null,null,"2030-12-31",null,"2025-11-01","Allerheiligen",null,"2027-02-08","2027-02-12","Winterferien 2027",null,"Sommerferien: 29. Juni 2026 – 7. August 2026",null,null,null,null,"Pfingstferien: 22. Mai 2029 – 25. Mai 2029"]
[null,null,"2031-12-24",null,"2025-12-25","1. Weihnachtsfeiertag",null,"2027-03-30","2027-04-09","Osterferien 2027",null,null,null,null,null,null,"Sommerferien: 16. Juli 2029 – 24. August 2029"]
[null,null,"2031-12-31",null,"2025-12-26","2. Weihnachtsfeiertag",null,"2027-06-28","2027-08-06","Sommerferien 2027",null,"Schuljahr 2026/27:"]
[null,null,"2032-12-24",null,"2026-01-01","Neujahr",null,"2027-10-04","2027-10-15","Herbstferien 2027",null,"Herbstferien: 5. Oktober 2026 – 16. Oktober 2026",null,null,null,null,"Schuljahr 2029/30:  "]
[null,null,"2032-12-31",null,"2026-04-03","Karfreitag",null,"2027-12-20","2027-12-31","Weihnachtsferien 2027",null,"Weihnachtsferien: 21. Dezember 2026 – 31. Dezember 2026",null,null,null,null,"Herbstferien: 22. Oktober 2029 – 2. November 2029"]
[null,null,"2033-12-24",null,"2026-04-05","Ostersonntag",null,"2028-02-21","2028-02-29","Winterferien 2030",null,"Fastnachtsferien: 8. Februar 2027 – 12. Februar 2027",null,null,null,null,"Weihnachtsferien: 21. Dezember 2029 – 4. Januar 2030"]
[null,null,"2033-12-31",null,"2026-04-06","Ostermontag",null,"2028-04-12","2028-04-21","Osterferien 2030",null,"Osterferien: 30. März 2027 – 9. April 2027",null,null,null,null,"Fastnachtsferien: 25. Februar 2030 – 5. März 2030"]
[null,null,"2034-12-24",null,"2026-05-01","Tag der Arbeit",null,"2028-07-03","2028-08-11","Sommerferien 2030",null,"Sommerferien: 28. Juni 2027 – 6. August 2027",null,null,null,null,"Osterferien: 15. April 2030 – 26. April 2030"]
[null,null,"2034-12-31",null,"2026-05-14","Christi Himmelfahrt",null,"2028-10-09","2028-10-20","Herbstferien 2030",null,null,null,null,null,null,"Sommerferien 22. Juli 2030 – 30. August 2030"]
[null,null,"2035-12-24",null,"2026-05-24","Pfingstsonntag",null,"2028-12-20","2029-01-02","Weihnachtsferien 2030",null,"*Ferien sind nur bis einschließlich der Sommerferien 2030 terminiert."]
[null,null,"2035-12-31",null,"2026-05-25","Pfingstmontag",null,"2029-02-12","2029-02-16","Winterferien 2029"]
[null,null,null,null,"2026-06-04","Fronleichnam",null,"2029-03-26","2029-04-06","Osterferien 2029"]
[null,null,null,null,"2026-08-15","Mariä Himmelfahrt",null,"2029-05-22","2029-05-25","Pfingstferien 2029"]
[null,null,null,null,"2026-10-03","Tag der Deutschen Einheit",null,"2029-07-16","2029-08-24","Sommerferien 2029"]
[null,null,null,null,"2026-11-01","Allerheiligen",null,"2029-10-22","2029-11-02","Herbstferien 2029"]
[null,null,null,null,"2026-12-25","1. Weihnachtsfeiertag",null,"2029-12-21","2030-01-04","Weihnachtsferien 2029"]
[null,null,null,null,"2026-12-26","2. Weihnachtsfeiertag",null,"2030-02-25","2030-03-05","Winterferien 2030"]
[null,null,null,null,"2027-01-01","Neujahr",null,"2030-04-15","2030-04-26","Osterferien 2030"]
[null,null,null,null,"2027-03-26","Karfreitag",null,"2030-07-22","2030-08-30","Sommerferien 2030"]
[null,null,null,null,"2027-03-28","Ostersonntag"]
[null,null,null,null,"2027-03-29","Ostermontag"]
[null,null,null,null,"2027-05-01","Tag der Arbeit"]
[null,null,null,null,"2027-05-06","Christi Himmelfahrt"]
[null,null,null,null,"2027-05-16","Pfingstsonntag"]
[null,null,null,null,"2027-05-17","Pfingstmontag"]
[null,null,null,null,"2027-05-27","Fronleichnam"]
[null,null,null,null,"2027-08-15","Mariä Himmelfahrt"]
[null,null,null,null,"2027-10-03","Tag der Deutschen Einheit"]
[null,null,null,null,"2027-11-01","Allerheiligen"]
[null,null,null,null,"2027-12-25","1. Weihnachtsfeiertag"]
[null,null,null,null,"2027-12-26","2. Weihnachtsfeiertag"]
[null,null,null,null,"2028-01-01","Neujahr"]
[null,null,null,null,"2028-04-14","Karfreitag"]
[null,null,null,null,"2028-04-16","Ostersonntag"]
[null,null,null,null,"2028-04-17","Ostermontag"]
[null,null,null,null,"2028-05-01","Tag der Arbeit"]
[null,null,null,null,"2028-05-25","Christi Himmelfahrt"]
[null,null,null,null,"2028-06-04","Pfingstsonntag"]
[null,null,null,null,"2028-06-05","Pfingstmontag"]
[null,null,null,null,"2028-06-15","Fronleichnam"]
[null,null,null,null,"2028-08-15","Mariä Himmelfahrt"]
[null,null,null,null,"2028-10-03","Tag der Deutschen Einheit"]
[null,null,null,null,"2028-11-01","Allerheiligen"]
[null,null,null,null,"2028-12-25","1. Weihnachtsfeiertag"]
[null,null,null,null,"2028-12-26","2. Weihnachtsfeiertag"]
[null,null,null,null,"2029-01-01","Neujahr"]
[null,null,null,null,"2029-03-30","Karfreitag"]
[null,null,null,null,"2029-04-01","Ostersonntag"]
[null,null,null,null,"2029-04-02","Ostermontag"]
[null,null,null,null,"2029-05-01","Tag der Arbeit"]
[null,null,null,null,"2029-05-10","Christi Himmelfahrt"]
[null,null,null,null,"2029-05-20","Pfingstsonntag"]
[null,null,null,null,"2029-05-21","Pfingstmontag"]
[null,null,null,null,"2029-05-31","Fronleichnam"]
[null,null,null,null,"2029-08-15","Mariä Himmelfahrt"]
[null,null,null,null,"2029-10-03","Tag der Deutschen Einheit"]
[null,null,null,null,"2029-11-01","Allerheiligen"]
[null,null,null,null,"2029-12-25","1. Weihnachtsfeiertag"]
[null,null,null,null,"2029-12-26","2. Weihnachtsfeiertag"]

{"sheet":"Feiertagsrechner","index":4,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[null,"Berechnung gesetzlicher Feiertage für das Saarland"]
[]
[null,"Jahr",2025]
[null,"Feiertage","Berechnung"]
[1,"Neujahr",{"$f":"DATE($C$3,1,1)","v":"2025-01-01"},"festes Datum"]
[2,"Karfreitag",{"$f":"7*ROUND((4&-$C$3)/7+MOD(19*MOD($C$3,19)-7,30)*0.14,)-6-2","v":"2025-04-18"},"festes Datum"]
[3,"Ostersonnatg",{"$f":"7*ROUND((4&-$C$3)/7+MOD(19*MOD($C$3,19)-7,30)*0.14,)-6","v":"2025-04-20"},"festes Datum"]
[4,"Ostermontag",{"$f":"7*ROUND((4&-$C$3)/7+MOD(19*MOD($C$3,19)-7,30)*0.14,)-6+1","v":"2025-04-21"},"festes Datum"]
[5,"Tag der Arbeit",{"$f":"DATE($C$3,5,1)","v":"2025-05-01"},"festes Datum"]
[6,"Christi Himmelfahrt",{"$f":"7*ROUND((4&-$C$3)/7+MOD(19*MOD($C$3,19)-7,30)*0.14,)-6+39","v":"2025-05-29"},"festes Datum"]
[7,"Pfingstsonntag",{"$f":"7*ROUND((4&-$C$3)/7+MOD(19*MOD($C$3,19)-7,30)*0.14,)-6+49","v":"2025-06-08"},"festes Datum"]
[8,"Pfingstmontag",{"$f":"7*ROUND((4&-$C$3)/7+MOD(19*MOD($C$3,19)-7,30)*0.14,)-6+50","v":"2025-06-09"}]
[9,"Fronleichnam",{"$f":"7*ROUND((4&-$C$3)/7+MOD(19*MOD($C$3,19)-7,30)*0.14,)-6+60","v":"2025-06-19"},"Ostersonntag - 2"]
[11,"Mariä Himmelfahrt",{"$f":"DATE($C$3,8,15)","v":"2025-08-15"},"Ostersonntag + 1"]
[12,"Tag der deutschen Einheit",{"$f":"DATE($C$3,10,3)","v":"2025-10-03"},"Ostersonntag + 39"]
[13,"Allerheiligen",{"$f":"DATE($C$3,11,1)","v":"2025-11-01"},"Ostersonntag + 49"]
[14,"1. Weihnachtsfeiertag",{"$f":"DATE($C$3,12,25)","v":"2025-12-25"},"Ostersonntag + 50"]
[15,"2. Weihnachtsfeiertag",{"$f":"DATE($C$3,12,26)","v":"2025-12-26"},"Ostersonntag + 60"]
[]
["*Berechnungen funktionieren für die Jahre 1900 bis 2203."]