{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Geordnet","Hinweise","Daten"],"not_rendered":{"images":3,"macros":1,"defined_names":1,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"Geordnet","index":0,"n_rows":50,"n_cols":9,"rows_kept":50}
[]
[null,"Geburtstagsliste",{"$nulls":5},"Geburtstage im Monat sind nach dem Tag sortiert!"]
[null,"Halbjahr","(Alle)",{"$nulls":4},"(Spalte D = Tag_im_Jahr ist ausgeblendet; sie wird zum Sortieren benötigt)"]
[]
[null,"Monate","Merkmal","Geburtstag","Tag_im_Jahr"]
[null,"Jan"]
[null,null,"O","1983-01-09",9,{"$nulls":3},"Pivot-Tabelle aktualisieren"]
[null,null,"S","2005-01-18",18]
[null,null,"K","2003-01-21",21]
[null,null,"H","2016-01-31",31,null,null,"Mit der Funktion \"Berichtsfilter anzeigen\" läßt sich der Bericht in zwei Tabellen (je Halbjahr) zum Drucken anzeigen"]
[null,"Feb",{"$nulls":5},"Spalte C kann wieder ausgeblendet werden."]
[null,null,"Holger","1968-02-12",43,null,null,"Anschliessend wird das Löschen der neuen Seiten empfohlen."]
[null,null,"Fritz","1910-02-23",54]
[null,null,"D","2018-02-28",59]
[null,null,"F","2016-02-29",60]
[null,"Mrz"]
[null,null,"E","2018-03-01",60]
[null,null,"G","2016-03-01",61]
[null,"Apr"]
[null,null,"C","2018-04-01",91]
[null,null,"Bettina","1954-04-04",94]
[null,null,"L","2006-04-27",117]
[null,"Mai"]
[null,null,"R","1965-05-10",130]
[null,null,"V","1995-05-15",135]
[null,"Jun"]
[null,null,"Elfriede","1933-06-16",167]
[null,"Jul"]
[null,null,"Y","2000-07-04",186]
[null,null,"I","1975-07-05",186]
[null,null,"M","1989-07-11",192]
[null,null,"Caroline","1964-07-22",204]
[null,"Aug"]
[null,null,"Dora","1977-08-17",229]
[null,null,"Q","1963-08-20",232]
[null,"Sep"]
[null,null,"Annegret","1953-09-04",247]
[null,null,"B","2018-09-06",249]
[null,null,"U","1953-09-12",255]
[null,null,"Z","2001-09-23",266]
[null,"Okt"]
[null,null,"N","1991-10-02",275]
[null,null,"Lucas","1988-10-21",295]
[null,"Nov"]
[null,null,"X","1986-11-06",310]
[null,null,"J","1965-11-18",322]
[null,null,"P","1963-11-21",325]
[null,"Dez"]
[null,null,"T","1980-12-11",346]
[null,null,"W","1973-12-25",359]

{"sheet":"Hinweise","index":1,"n_rows":16,"n_cols":10,"rows_kept":16}
[]
[null,"Berechnung einer Datumsdifferenz, z.B. zum Beginn des Jahres"]
[]
[null,"Geben Sie einen neuen Datensatz, bestehend aus Person/Name/Merkmal und dem Geburtsdatum, am Ende der Liste in einer neuen Zeile ein."]
[null,"Sie können auch in die Tabelle klicken und das Symbol Maske aus der Symbolleiste aufrufen und auf Neu klicken",{"$nulls":6},1,"Monat später"]
[]
[]
[null,"Geburtstage im Monat in der geordneten Tabelle  sind nach dem Tag sortiert!"]
[]
[null,"Nach einer Idee von Lucas Rohr - ExcelNova"]
[null,"https://excelnova.org/2018/09/referenzlisten-verwalten-in-excel-geburtstage-telefonlisten-kunden-produkte-etc/"]
[]
[]
[null,"Freundliche Grüße"]
[null,"Irina Stobbe"]
[null,"www.steam-service.de"]

{"sheet":"Daten","index":2,"n_rows":34,"n_cols":16,"rows_kept":34}
["Merkmal","Datum","Zahl","Datedif","ExcelNova1","Brteiljahre","  minus Datum","Tage","EDATUM","DATUM + x Monate","Monat","Halbjahr",null,null,0,"Monat später (für EDATUM)"]
["Annegret","1953-09-04",{"$f":"B2","v":19606},{"$f":"DATEDIF(DATE(YEAR(B2),1,0),B2,\"d\")","v":247},{"$f":"DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))-DATE(YEAR(TODAY()),1,0)","v":247},{"$f":"YEARFRAC(DATE(YEAR(B2),1,0),B2,3)*365","v":247},{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-09-03"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":247},{"$f":"EDATE(B2,$O$1)","v":"1953-09-04"},{"$f":"DATE(YEAR(B2),MONTH(B2)+$O$1,DAY(B2))","v":"1953-09-04"},{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":9},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["B","2018-09-06",43349,249,249,249,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-09-05"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":249},"2018-09-06","2018-09-06",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":9},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["C","2018-04-01",43191,91,91,91,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-03-31"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":91},"2018-04-01","2018-04-01",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":4},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1},null,"Neu klicken für neuen Datensatz"]
["D","2018-02-28",43159,59,59,59,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-02-28"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":59},"2018-02-28","2018-02-28",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":2},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["E","2018-03-01",43160,60,60,60,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":60},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":60},"2018-03-01","2018-03-01",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":3},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1},null,"Tabelle enthält mehrere Spalten zum Zeigen verschiedener Möglichkeiten."]
["F","2016-02-29",42429,60,60,60,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":60},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":60},"2016-02-29","2016-02-29",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":2},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1},null,"Davon genutzt werden nur die Spalten Merkmal, Datum und Datedif, zum Filtern auch Monat und Halbjahr"]
["G","2016-03-01",42430,61,60,61,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-03-01"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":61},"2016-03-01","2016-03-01",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":3},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["H","2016-01-31",42400,31,31,31,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-01-31"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":31},"2016-01-31","2016-01-31",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":1},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1},null,"ExcelNova1","im Schaltjahr nicht korrekt, Reihenfolge bleibt aber erhalten"]
["I","1975-07-05",{"$f":"B10","v":27580},{"$f":"DATEDIF(DATE(YEAR(B10),1,0),B10,\"d\")","v":186},186,{"$f":"YEARFRAC(DATE(YEAR(B10),1,0),B10,3)*365","v":186},{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-07-04"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":186},"1975-07-05","1975-07-05",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":7},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["J","1965-11-18",24064,322,322,322,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-11-17"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":322},"1965-11-18","1965-11-18",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":11},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["K","2003-01-21",37642,21,21,21,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-01-21"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":21},"2003-01-21","2003-01-21",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":1},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["L","2006-04-27",38834,117,117,117,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-04-26"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":117},"2006-04-27","2006-04-27",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":4},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["M","1989-07-11",32700,192,192,191.99999999999997,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-07-10"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":192},"1989-07-11","1989-07-11",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":7},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["N","1991-10-02",33513,275,275,275,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-10-01"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":275},"1991-10-02","1991-10-02",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":10},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["O","1983-01-09",30325,9,9,9,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-01-09"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":9},"1983-01-09","1983-01-09",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":1},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["P","1963-11-21",23336,325,325,325,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-11-20"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":325},"1963-11-21","1963-11-21",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":11},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["Q","1963-08-20",23243,232,232,232.00000000000003,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-08-19"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":232},"1963-08-20","1963-08-20",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":8},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["R","1965-05-10",23872,130,130,130,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-05-09"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":130},"1965-05-10","1965-05-10",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":5},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["S","2005-01-18",38370,18,18,18,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-01-18"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":18},"2005-01-18","2005-01-18",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":1},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["T","1980-12-11",29566,346,345,346,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-12-11"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":346},"1980-12-11","1980-12-11",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":12},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["U","1953-09-12",19614,255,255,255,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-09-11"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":255},"1953-09-12","1953-09-12",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":9},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["V","1995-05-15",34834,135,135,135,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-05-14"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":135},"1995-05-15","1995-05-15",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":5},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["W","1973-12-25",27023,359,359,359,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-12-24"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":359},"1973-12-25","1973-12-25",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":12},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["X","1986-11-06",31722,310,310,310,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-11-05"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":310},"1986-11-06","1986-11-06",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":11},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["Y","2000-07-04",36711,186,185,186,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-07-04"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":186},"2000-07-04","2000-07-04",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":7},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["Z","2001-09-23",37157,266,266,266,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-09-22"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":266},"2001-09-23","2001-09-23",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":9},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["Bettina","1954-04-04",{"$f":"B28","v":19818},{"$f":"DATEDIF(DATE(YEAR(B28),1,0),B28,\"d\")","v":94},94,{"$f":"YEARFRAC(DATE(YEAR(B28),1,0),B28,3)*365","v":94},{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-04-03"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":94},"1954-04-04","1954-04-04",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":4},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["Caroline","1964-07-22",23580,204,203,204,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-07-22"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":204},"1964-07-22","1964-07-22",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":7},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["Dora","1977-08-17",28354,229,229,229,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-08-16"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":229},"1977-08-17","1977-08-17",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":8},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["Fritz","1910-02-23",3707,54,54,54,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-02-23"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":54},"1910-02-23","1910-02-23",{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":2},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["Elfriede","1933-06-16",12221,167,167,167,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-06-15"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":167},{"$f":"EDATE(B32,$O$1)","v":"1933-06-16"},{"$f":"DATE(YEAR(B32),MONTH(B32)+$O$1,DAY(B32))","v":"1933-06-16"},{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":6},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]
["Lucas","1988-10-21",32437,295,294,295,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-10-21"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":295},{"$f":"EDATE(B33,$O$1)","v":"1988-10-21"},{"$f":"DATE(YEAR(B33),MONTH(B33)+$O$1,DAY(B33))","v":"1988-10-21"},{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":10},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":2}]
["Holger","1968-02-12",24880,43,43,43,{"$f":"tabDaten[[#This Row],[Datum]]-DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0)","v":"1900-02-12"},{"$f":"_xlfn.DAYS(tabDaten[[#This Row],[Datum]],DATE(YEAR(tabDaten[[#This Row],[Datum]]),1,0))","v":43},{"$f":"EDATE(B34,$O$1)","v":"1968-02-12"},{"$f":"DATE(YEAR(B34),MONTH(B34)+$O$1,DAY(B34))","v":"1968-02-12"},{"$f":"MONTH(tabDaten[[#This Row],[Datum]])","v":2},{"$f":"IF(MONTH(tabDaten[[#This Row],[Datum]])<=6,1,2)","v":1}]