{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle2 alt"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"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-12"},"Franziska","1981-01-12",{"$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 8  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":23},{"$f":"IF(C2=0,\"\",DATE(YEAR(C2)+DATEDIF(C2,TODAY(),\"Y\")+1,MONTH(C2),DAY(C2)))","v":"2025-01-12"},{"$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-08-04"},"Michi","1952-08-04",{"$f":"DATEDIF(C3,TODAY(),\"y\")&\" J\"","v":"72 J"},"Michi   ist 72 Jahre,  4 Monate,  und 16  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":"Löwe:"},227,"2025-08-04","73 J",null,null,null,null,null,"2024-01-20","Wassermann:"]
["2024-12-27","Melanie","1986-12-27",{"$f":"DATEDIF(C4,TODAY(),\"y\")&\" J\"","v":"37 J"},"Melanie   ist 37 Jahre,  11 Monate,  und 23  Tage",7,"Wassermann:",7,"2024-12-27","38 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 8  Tage","","Widder:",113,"2025-04-12",{"$f":"DATEDIF(C5,TODAY(),\"y\")+1&\" J\"","v":"22 J"},null,null,null,null,null,"2024-03-21","Widder:"]
["2024-03-06","Sabine","1959-03-06","65 J","Sabine   ist 65 Jahre,  9 Monate,  und 14  Tage","","Fische:",76,"2025-03-06","66 J",null,null,null,null,null,"2024-04-20","Stier:"]
["2024-01-20","Petra","1955-01-20","69 J","Petra   ist 69 Jahre,  11 Monate,  und 0  Tage","","Wassermann:",31,"2025-01-20","70 J",null,null,null,null,null,"2024-05-21","Zwillinge:"]
["2024-10-29","David","1988-10-29","36 J","David   ist 36 Jahre,  1 Monate,  und 21  Tage","","Skorpion:",313,"2025-10-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,{"$f":"XVerweis(A4,Tabelle1!$I$2:$I$56,Tabelle1!$B$2:$B$56,FALSE)& \" in \"&A4-TODAY()&\" Tagen\"","v":{"$error":"#NAME?"}},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":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"TODAY()","v":"2024-12-20"},"Namen","Datum",null,null,"geht auch nur halbwegs"]
[null,null,null,null,null,null,"AGGREGAT letzter","AGGREGAT hat nächster","AGGREGAT 2","AGGREGAT 3"]
[null,null,"hatte letzten Geburtstag",{"$f":"VLOOKUP($E4,Tabelle1!$A$2:$B$56,2,FALSE)","v":"David"},{"$f":"_xlfn.MAXIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\"<=\"& TODAY())","v":"2024-10-29"},null,{"$f":"_xlfn.AGGREGATE(14,6,Tabelle1!$A$2:$A$40/(Tabelle1!$A$2:$A$40<TODAY()),1)","v":"2024-10-29"},{"$f":"_xlfn.AGGREGATE(15,6,Tabelle1!$A$2:$A$40/(Tabelle1!$A$2:$A$40>TODAY()),1)","v":"2024-12-27"},{"$f":"_xlfn.AGGREGATE(15,6,Tabelle1!$I$2:$I$40/(Tabelle1!$I$2:$I$40>TODAY()),2)","v":"2025-01-12"},{"$f":"_xlfn.AGGREGATE(15,6,Tabelle1!$I$2:$I$40/(Tabelle1!$I$2:$I$40>TODAY()),3)","v":"2025-01-20"}]
[]
[null,null,"Hat Geburtstag nach dem letzten",{"$f":"XVerweis($E6,Tabelle1!$A$2:$A$56,Tabelle1!$B$2:$B$56,FALSE)& \" in \"&$E6-TODAY()&\" Tagen\"","v":{"$error":"#NAME?"}},{"$f":"_xlfn.MINIFS(Tabelle1!$I$2:$I$50,Tabelle1!$I$2:$I$50,\">\"&$E4)","v":"2024-12-27"},null,{"$f":"VLOOKUP($E6,Tabelle1!$A$2:$B$50,2,FALSE)","v":"Melanie"},null,{"$f":"_xlfn.MINIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\">\"& TODAY(),Tabelle1!$I$2:$I$50,\">\"&$E4)","v":"2024-12-27"},{"$f":"VLOOKUP(I6,Tabelle1!$A$2:$B$56,2,FALSE)","v":"Melanie"}]
[null,null,"nächster Geburtstag",{"$f":"XVerweis($E7,Tabelle1!$A$2:$A$56,Tabelle1!$B$2:$B$56,FALSE)& \" in \"&$E7-TODAY()&\" Tagen\"","v":{"$error":"#NAME?"}},{"$f":"_xlfn.MINIFS(Tabelle1!$I$2:$I$50,Tabelle1!$I$2:$I$50,\">\"&$E6)","v":"2025-01-12"},null,{"$f":"VLOOKUP($E7,Tabelle1!A2:B9,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.MINIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\"<\"& TODAY(),Tabelle1!$I$2:$I$50,\">\"&$E6)","v":"2024-01-12"},{"$f":"VLOOKUP(I7,Tabelle1!$A$2:$B$56,2,FALSE)","v":"Franziska"}]
[null,null,"übernächster Geburtstag",{"$f":"XVerweis($E8,Tabelle1!$A$2:$A$56,Tabelle1!$B$2:$B$56,FALSE)& \" in \"&$E8-TODAY()&\" Tagen\"","v":{"$error":"#NAME?"}},{"$f":"_xlfn.MINIFS(Tabelle1!$I$2:$I$50,Tabelle1!$I$2:$I$50,\">\"&$E7)","v":"2025-01-20"},null,{"$f":"VLOOKUP($E8,Tabelle1!$A$2:$I$50,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"_xlfn.MINIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\"<\"& TODAY(),Tabelle1!$I$2:$I$50,\">\"&$E7)","v":"2024-01-20"},{"$f":"VLOOKUP(I8,Tabelle1!$A$2:$B$56,2,FALSE)","v":"Petra"}]
[null,null,null,"XVerweis ---- geht nicht",null,"geht nur wenn Jahr 2025",null,null,"geht nur wenn dieses Jahr"]
[]
[]
[]
[]
[]
[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-12"},{"$f":"DATE(YEAR(D19)+DATEDIF(D19,TODAY(),\"Y\")+1,MONTH(D19),DAY(D19))","v":"2025-01-12"}]
[null,2,{"$f":"VLOOKUP(D20,Tabelle1!A2:D8,2,0)","v":"Petra"},{"$f":"SMALL(Tabelle1!A2:A8,Tabelle2!B20)","v":"2024-01-20"},"2025-01-20"]
[null,3,{"$f":"VLOOKUP(D21,Tabelle1!A2:D8,2,0)","v":"Sabine"},{"$f":"SMALL(Tabelle1!A2:A8,Tabelle2!B21)","v":"2024-03-06"},"2025-03-06"]

{"sheet":"Tabelle2 alt","index":2,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"TODAY()","v":"2024-12-20"},"Namen","Datum"]
[]
[null,null,"hatte letzten Geburtstag",{"$f":"VLOOKUP($E4,Tabelle1!$A$2:$B$56,2,FALSE)","v":"David"},{"$f":"_xlfn.MAXIFS(Tabelle1!$A$2:$A$50,Tabelle1!$A$2:$A$50,\"<=\"& TODAY())","v":"2024-10-29"},null,null,"hier müßte bei datum 21.11.2024 und bei Name Melanie stehen"]
[]
[null,null,"Hat Geburtstag nach dem letzten",{"$f":"INDEX(Tabelle1!B2:B8,MATCH(MIN(Tabelle1!H2:H8),Tabelle1!H2:H8,0))&\" in Tage(n) \"&INDEX(Tabelle1!H2:H8,MATCH(MIN(Tabelle1!H2:H8),Tabelle1!H2:H8,0))","v":"Melanie in Tage(n) 7"},{"$f":"IF(ROW(Tabelle1!A2)>COUNT(Tabelle1!A:A),\"\",TODAY()+SMALL(IF(Tabelle1!A$2:A$21<\"\",DATE((TEXT(Tabelle1!A$2:A$21,\"MM/TT\")<TEXT(TODAY(),\"MM/TT\"))+YEAR(TODAY()),MONTH(Tabelle1!A$2:A$21),DAY(Tabelle1!A$2:A$21))-TODAY()),ROW(Tabelle1!A1)))","v":"2024-12-27"},null,null,"hier stimmt alles"]
[]
[null,null,"nächster Geburtstag","namen für den nächsten geburtstag",{"$f":"IF(ROW(Tabelle1!A3)>COUNT(Tabelle1!A:A),\"\",TODAY()+SMALL(IF(Tabelle1!A$2:A$21<\"\",DATE((TEXT(Tabelle1!A$2:A$21,\"MM/TT\")<TEXT(TODAY(),\"MM/TT\"))+YEAR(TODAY()),MONTH(Tabelle1!A$2:A$21),DAY(Tabelle1!A$2:A$21))-TODAY()),ROW(Tabelle1!A2)))","v":"2025-01-12"},null,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(Tabelle1!A4)>COUNT(Tabelle1!A:A),\"\",TODAY()+SMALL(IF(Tabelle1!A$2:A$21<\"\",DATE((TEXT(Tabelle1!A$2:A$21,\"MM/TT\")<TEXT(TODAY(),\"MM/TT\"))+YEAR(TODAY()),MONTH(Tabelle1!A$2:A$21),DAY(Tabelle1!A$2:A$21))-TODAY()),ROW(Tabelle1!A3)))","v":"2025-01-20"},null,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,Tabelle1!A2:D8,2,0)","v":"Franziska"},{"$f":"SMALL(Tabelle1!A2:A8,'Tabelle2 alt'!B22)","v":"2024-01-12"},{"$f":"DATE(YEAR(D22)+DATEDIF(D22,TODAY(),\"Y\")+1,MONTH(D22),DAY(D22))","v":"2025-01-12"}]
[null,2,{"$f":"VLOOKUP(D23,Tabelle1!A2:D8,2,0)","v":"Petra"},{"$f":"SMALL(Tabelle1!A2:A8,'Tabelle2 alt'!B23)","v":"2024-01-20"},"2025-01-20"]
[null,3,{"$f":"VLOOKUP(D24,Tabelle1!A2:D8,2,0)","v":"Sabine"},{"$f":"SMALL(Tabelle1!A2:A8,'Tabelle2 alt'!B24)","v":"2024-03-06"},"2025-03-06"]