{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle2 (2)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"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":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["dieses Jahr","Namen","Geburtsjahr","Alter","Wie alt genau",null,"Sternzeichen","Bis Geburtstag","Nächster Geburtstag","wird alt",2024,"Tage bis","nächster","Tage bis"]
[{"$f":"DATE(K$1,MONTH(C2),DAY(C2))","v":"2024-01-07"},"Franziska","1981-01-07",{"$f":"DATEDIF(C2,TODAY(),\"y\")&\" J\"","v":"43 J"},{"$f":"IF(C2=\"\",\"\",(B2&\"   ist \"&DATEDIF(C2,TODAY(),\"y\")&\" Jahre,  \"&DATEDIF(C2,TODAY(),\"ym\")&\" Monate,  und \"&DATEDIF(C2,TODAY(),\"md\")&\"  Tage\"))","v":"Franziska   ist 43 Jahre,  11 Monate,  und 7  Tage"},{"$f":"IF(DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))<TODAY()+1,\"\",DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))-TODAY())","v":""},{"$f":"VLOOKUP(A2,$P$2:$Q$16,2)","v":"Steinbock:"},{"$f":"DATE(YEAR(TODAY())+(DATE(YEAR(TODAY()),MONTH(C2),DAY(C2))<TODAY()),MONTH(C2),DAY(C2))-TODAY()","v":24},{"$f":"IF(C2=0,\"\",DATE(YEAR(C2)+DATEDIF(C2,TODAY(),\"Y\")+1,MONTH(C2),DAY(C2)))","v":"2025-01-07"},{"$f":"DATEDIF(C2,TODAY(),\"y\")+1&\" J\"","v":"44 J"},null,null,null,null,null,"2024-01-01","Steinbock:"]
[{"$f":"DATE(K$1,MONTH(C3),DAY(C3))","v":"2024-02-04"},"Michi","1952-02-04",{"$f":"DATEDIF(C3,TODAY(),\"y\")&\" J\"","v":"72 J"},"Michi   ist 72 Jahre,  10 Monate,  und 10  Tage",{"$f":"IF(DATE(YEAR(TODAY()),MONTH(C3),DAY(C3))<TODAY()+1,\"\",DATE(YEAR(TODAY()),MONTH(C3),DAY(C3))-TODAY())","v":""},{"$f":"VLOOKUP(A3,$P$2:$Q$16,2)","v":"Wassermann:"},52,"2025-02-04","73 J",null,null,null,null,null,"2024-01-20","Wassermann:"]
["2024-11-21","Melanie","1986-11-21",{"$f":"DATEDIF(C4,TODAY(),\"y\")&\" J\"","v":"38 J"},"Melanie   ist 38 Jahre,  0 Monate,  und 23  Tage","","Skorpion:",342,"2025-11-21","39 J",null,null,null,null,null,"2024-02-19","Fische:"]
["2024-04-12","Leon","2003-04-12",{"$f":"DATEDIF(C5,TODAY(),\"y\")&\" J\"","v":"21 J"},"Leon   ist 21 Jahre,  8 Monate,  und 2  Tage","","Widder:",119,"2025-04-12",{"$f":"DATEDIF(C5,TODAY(),\"y\")+1&\" J\"","v":"22 J"},null,null,null,null,null,"2024-03-21","Widder:"]
["2024-12-26","Sabine","1959-12-26","64 J","Sabine   ist 64 Jahre,  11 Monate,  und 18  Tage",12,"Wassermann:",12,"2024-12-26","65 J",null,null,null,null,null,"2024-04-20","Stier:"]
["2024-12-24","Petra","1955-12-24","68 J","Petra   ist 68 Jahre,  11 Monate,  und 20  Tage",10,"Wassermann:",10,"2024-12-24","69 J",null,null,null,null,null,"2024-05-21","Zwillinge:"]
["2024-03-29","David","1988-03-29","36 J","David   ist 36 Jahre,  8 Monate,  und 15  Tage","","Widder:",105,"2025-03-29","37 J",null,null,null,null,null,"2024-06-21","Krebs:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-23","Löwe:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-23","Jungfrau:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-23","Waage:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-23","Skorpion:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-22","Schütze:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-22","Steinbock:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-20","Wassermann:"]

{"sheet":"Tabelle2","index":1,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"TODAY()","v":"2024-12-14"},"Namen","Datum"]
[]
[null,null,"hatte letzten Geburtstag",{"$f":"VLOOKUP($E4,Tabelle1!$A$2:$B$56,2,FALSE)","v":"Melanie"},{"$f":"_xlfn.MAXIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\"<=\"& TODAY())","v":"2024-11-21"},{"$f":"_xlfn.MAXIFS(Tabelle1!A2:A50,Tabelle1!A2:A50,\"<=\"& TODAY())","v":"2024-11-21"},"hier müßte bei datum 21.11.2024 und bei Name Melanie stehen"]
[]
[null,null,"Hat Geburtstag nach dem letzten",{"$f":"_xlfn.XLOOKUP($E6,Tabelle1!$I$2:$I$56,Tabelle1!$B$2:$B$56,FALSE)& \" in \"&$E6-TODAY()&\" Tagen\"","v":"Petra in 10 Tagen"},{"$f":"_xlfn.MINIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\">\"& TODAY())","v":"2024-12-24"},{"$f":"_xlfn.MINIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\">\"& TODAY())","v":"2024-12-24"},"hier stimmt alles"]
[null,null,"nächster Geburtstag",{"$f":"_xlfn.XLOOKUP($E7,Tabelle1!$I$2:$I$56,Tabelle1!$B$2:$B$56,FALSE)& \" in \"&$E7-TODAY()&\" Tagen\"","v":"Sabine in 12 Tagen"},{"$f":"_xlfn.MINIFS(Tabelle1!$I$2:$I$50,Tabelle1!$I$2:$I$50,\">\"&$E6)","v":"2024-12-26"},null,"hier Datum richtig, bei Namen müßte Sabine hin"]
[null,null,"übernächster Geburtstag",{"$f":"_xlfn.XLOOKUP($E8,Tabelle1!$I$2:$I$56,Tabelle1!$B$2:$B$56,FALSE)& \" in \"&$E8-TODAY()&\" Tagen\"","v":"Franziska in 24 Tagen"},{"$f":"_xlfn.MINIFS(Tabelle1!$I$2:$I$50,Tabelle1!$I$2:$I$50,\">\"&$E7)","v":"2025-01-07"},null,"hier Datum richtig, und Name müßte Franziska hin"]
[null,null,null,"Datum wechsel","geht",null,{"$f":"_xlfn.MINIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\">\"& TODAY(),Tabelle1!$I$2:$I$50,\">\"&$E7)","v":0}]
[]
[]
[]
[]
[]
[null,null,"Versuche gehen nur halbwegs für laufendes Jahr"]
[]
[null,"Nr","Name","dieses Jahr","nächstes Jahr"]
[]
[null,1,{"$f":"VLOOKUP(D19,Tabelle1!A2:D8,2,0)","v":"Franziska"},{"$f":"SMALL(Tabelle1!A2:A8,Tabelle2!B19)","v":"2024-01-07"},{"$f":"DATE(YEAR(D19)+DATEDIF(D19,TODAY(),\"Y\")+1,MONTH(D19),DAY(D19))","v":"2025-01-07"}]
[null,2,{"$f":"VLOOKUP(D20,Tabelle1!A2:D8,2,0)","v":"Michi"},{"$f":"SMALL(Tabelle1!A2:A8,Tabelle2!B20)","v":"2024-02-04"},"2025-02-04"]
[null,3,{"$f":"VLOOKUP(D21,Tabelle1!A2:D8,2,0)","v":"David"},{"$f":"SMALL(Tabelle1!A2:A8,Tabelle2!B21)","v":"2024-03-29"},"2025-03-29"]

{"sheet":"Tabelle2 (2)","index":2,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"TODAY()","v":"2024-12-14"},"Namen","Datum"]
[]
[null,null,"hatte letzten Geburtstag","soll namen stehen wer zuletzt hatte",{"$f":"IF(ROW([1]Tabelle1!A2)>COUNT([1]Tabelle1!A:A),\"\",TODAY()+SMALL(IF([1]Tabelle1!A$2:A$21<\"\",DATE((TEXT([1]Tabelle1!A$2:A$21,\"MM/TT\")<TEXT(TODAY(),\"MM/TT\"))+YEAR(TODAY()),MONTH([1]Tabelle1!A$2:A$21),DAY([1]Tabelle1!A$2:A$21))-TODAY()),ROW([1]Tabelle1!A1)))","v":"2024-12-24"},null,"hier müßte bei datum 21.11.2024 und bei Name Melanie stehen"]
[]
[null,null,"Hat Geburtstag nach dem letzten",{"$f":"INDEX([1]Tabelle1!B2:B8,MATCH(MIN([1]Tabelle1!H2:H8),[1]Tabelle1!H2:H8,0))&\" in Tage(n) \"&INDEX([1]Tabelle1!H2:H8,MATCH(MIN([1]Tabelle1!H2:H8),[1]Tabelle1!H2:H8,0))","v":"Petra in Tage(n) 10"},{"$f":"IF(ROW([1]Tabelle1!A2)>COUNT([1]Tabelle1!A:A),\"\",TODAY()+SMALL(IF([1]Tabelle1!A$2:A$21<\"\",DATE((TEXT([1]Tabelle1!A$2:A$21,\"MM/TT\")<TEXT(TODAY(),\"MM/TT\"))+YEAR(TODAY()),MONTH([1]Tabelle1!A$2:A$21),DAY([1]Tabelle1!A$2:A$21))-TODAY()),ROW([1]Tabelle1!A1)))","v":"2024-12-24"},null,"hier stimmt alles"]
[]
[null,null,"nächster Geburtstag","namen für den nächsten geburtstag",{"$f":"IF(ROW([1]Tabelle1!A3)>COUNT([1]Tabelle1!A:A),\"\",TODAY()+SMALL(IF([1]Tabelle1!A$2:A$21<\"\",DATE((TEXT([1]Tabelle1!A$2:A$21,\"MM/TT\")<TEXT(TODAY(),\"MM/TT\"))+YEAR(TODAY()),MONTH([1]Tabelle1!A$2:A$21),DAY([1]Tabelle1!A$2:A$21))-TODAY()),ROW([1]Tabelle1!A2)))","v":"2024-12-26"},null,"hier Datum richtig, bei Namen müßte Sabine hin"]
[]
[null,null,"übernächster Geburtstag","namen für den übernächsten geburtstag",{"$f":"IF(ROW([1]Tabelle1!A4)>COUNT([1]Tabelle1!A:A),\"\",TODAY()+SMALL(IF([1]Tabelle1!A$2:A$21<\"\",DATE((TEXT([1]Tabelle1!A$2:A$21,\"MM/TT\")<TEXT(TODAY(),\"MM/TT\"))+YEAR(TODAY()),MONTH([1]Tabelle1!A$2:A$21),DAY([1]Tabelle1!A$2:A$21))-TODAY()),ROW([1]Tabelle1!A3)))","v":"2025-01-07"},null,"hier Datum richtig, und Name müßte Franziska hin"]
[]
[null,null,null,"Datum wechsel","geht"]
[]
[]
[]
[]
[]
[null,null,"Versuche gehen nur halbwegs für laufendes Jahr"]
[]
[null,"Nr","Name","dieses Jahr","nächstes Jahr"]
[]
[null,1,{"$f":"VLOOKUP(D22,[1]Tabelle1!A2:D8,2,0)","v":"Franziska"},{"$f":"SMALL([1]Tabelle1!A2:A8,'Tabelle2 (2)'!B22)","v":"2024-01-07"},{"$f":"DATE(YEAR(D22)+DATEDIF(D22,TODAY(),\"Y\")+1,MONTH(D22),DAY(D22))","v":"2025-01-07"}]
[null,2,{"$f":"VLOOKUP(D23,[1]Tabelle1!A2:D8,2,0)","v":"Michi"},{"$f":"SMALL([1]Tabelle1!A2:A8,'Tabelle2 (2)'!B23)","v":"2024-02-04"},"2025-02-04"]
[null,3,{"$f":"VLOOKUP(D24,[1]Tabelle1!A2:D8,2,0)","v":"David"},{"$f":"SMALL([1]Tabelle1!A2:A8,'Tabelle2 (2)'!B24)","v":"2024-03-29"},"2025-03-29"]