{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["now","days","date","datedif","Mac","edate","weeknum","weekNum2date","Lotus Day"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"now","index":0,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["NOW","NU"]
["NOW","NU",{"$f":"NOW()","v":"2021-01-08T08:25:48.330"},"DDD ÅÅÅÅ-MM-DD"]
[null,null,{"$f":"NOW()","v":44204.351253819441},"*Tid (Systemformat)"]
[null,null,{"$f":"NOW()","v":"2021-01-08T08:25:48.330"},"DDD ÅÅÅÅ-MM-DD* tt:mm:ss,0"]

{"sheet":"days","index":1,"n_rows":370,"n_cols":8,"rows_kept":370,"cut":false,"hidden":false,"merged":[]}
["Arbetsdagar"]
[null,"Röda dagar"]
["2013-01-01","Nyårsdagen 2013",null,null,"From",{"$f":"INT(NOW()-DAY(NOW())+1)","v":"2021-01-01"},null,"Datum"]
["2013-01-06","Trettondedag jul 2013",null,null,"Tom",{"$f":"EDATE(INT(NOW()-DAY(NOW())+1),1)-1","v":"2021-01-31"},null,{"$f":"From","v":"2021-01-01"}]
["2013-02-14","Alla hjärtans dag 2013",null,null,"Vardagar",{"$f":"SUM(N(ISNUMBER(dates))*N(WEEKDAY(dates)>1)*N(WEEKDAY(dates)<7)*N(dates>=From)*N(dates<=Tom))","v":21},null,{"$f":"H4+1","v":"2021-01-02"}]
["2013-03-28","Skärtorsdagen 2013",null,null,"Arbetsdagar ->",{"$f":"WORKDAY.INTL(From,F5-1,1,A3:A202)","v":"2021-01-29"},null,"2021-01-03"]
["2013-03-29","Långfredagen 2013",null,null,null,null,null,"2021-01-04"]
["2013-03-31","Påsk 2013",null,null,null,null,null,"2021-01-05"]
["2013-03-31","Sommartid 2013",null,null,null,null,null,"2021-01-06"]
["2013-04-01","Annandag påsk 2013",null,null,null,null,null,"2021-01-07"]
["2013-05-01","Första maj 2013",null,null,null,null,null,"2021-01-08"]
["2013-05-09","Kristi Himmelsfärdsdag 2013",null,null,null,null,null,"2021-01-09"]
["2013-05-19","Pingstdagen 2013",null,null,null,null,null,"2021-01-10"]
["2013-05-20","Annandag pingst 2013",null,null,null,null,null,"2021-01-11"]
["2013-05-26","Mors dag 2013",null,null,null,null,null,"2021-01-12"]
["2013-06-06","Sveriges nationaldag 2013",null,null,null,null,null,"2021-01-13"]
["2013-06-21","Midsommarafton 2013",null,null,null,null,null,"2021-01-14"]
["2013-06-22","Midsommardagen 2013",null,null,null,null,null,"2021-01-15"]
["2013-10-27","Vintertid 2013",null,null,null,null,null,"2021-01-16"]
["2013-10-31","Halloween 2013",null,null,null,null,null,"2021-01-17"]
["2013-11-02","Alla helgons dag 2013",null,null,null,null,null,"2021-01-18"]
["2013-11-10","Fars dag 2013",null,null,null,null,null,"2021-01-19"]
["2013-12-13","Lucia 2013",null,null,null,null,null,"2021-01-20"]
["2013-12-24","Julafton 2013",null,null,null,null,null,"2021-01-21"]
["2013-12-25","Juldagen 2013",null,null,null,null,null,"2021-01-22"]
["2013-12-26","Annandag jul 2013",null,null,null,null,null,"2021-01-23"]
["2013-12-31","Nyårsafton 2013",null,null,null,null,null,"2021-01-24"]
["2014-01-01","Nyårsdagen 2014",null,null,null,null,null,"2021-01-25"]
["2014-01-06","Trettondedag jul 2014",null,null,null,null,null,"2021-01-26"]
["2014-02-14","Alla hjärtans dag 2014",null,null,null,null,null,"2021-01-27"]
["2014-03-30","Sommartid 2014",null,null,null,null,null,"2021-01-28"]
["2014-04-17","Skärtorsdagen 2014",null,null,null,null,null,"2021-01-29"]
["2014-04-18","Långfredagen 2014",null,null,null,null,null,"2021-01-30"]
["2014-04-20","Påsk 2014",null,null,null,null,null,"2021-01-31"]
["2014-04-21","Annandag påsk 2014",null,null,null,null,null,"2021-02-01"]
["2014-05-01","Första maj 2014",null,null,null,null,null,"2021-02-02"]
["2014-05-25","Mors dag 2014",null,null,null,null,null,"2021-02-03"]
["2014-05-29","Kristi Himmelsfärdsdag 2014",null,null,null,null,null,"2021-02-04"]
["2014-06-06","Sveriges nationaldag 2014",null,null,null,null,null,"2021-02-05"]
["2014-06-08","Pingstdagen 2014",null,null,null,null,null,"2021-02-06"]
["2014-06-09","Annandag pingst 2014",null,null,null,null,null,"2021-02-07"]
["2014-06-20","Midsommarafton 2014",null,null,null,null,null,"2021-02-08"]
["2014-06-21","Midsommardagen 2014",null,null,null,null,null,"2021-02-09"]
["2014-10-26","Vintertid 2014",null,null,null,null,null,"2021-02-10"]
["2014-10-31","Halloween 2014",null,null,null,null,null,"2021-02-11"]
["2014-11-01","Alla helgons dag 2014",null,null,null,null,null,"2021-02-12"]
["2014-11-09","Fars dag 2014",null,null,null,null,null,"2021-02-13"]
["2014-12-13","Lucia 2014",null,null,null,null,null,"2021-02-14"]
["2014-12-24","Julafton 2014",null,null,null,null,null,"2021-02-15"]
["2014-12-25","Juldagen 2014",null,null,null,null,null,"2021-02-16"]
["2014-12-26","Annandag jul 2014",null,null,null,null,null,"2021-02-17"]
["2014-12-31","Nyårsafton 2014",null,null,null,null,null,"2021-02-18"]
["2015-01-01","Nyårsdagen 2015",null,null,null,null,null,"2021-02-19"]
["2015-01-06","Trettondedag jul 2015",null,null,null,null,null,"2021-02-20"]
["2015-02-14","Alla hjärtans dag 2015",null,null,null,null,null,"2021-02-21"]
["2015-03-29","Sommartid 2015",null,null,null,null,null,"2021-02-22"]
["2015-04-02","Skärtorsdagen 2015",null,null,null,null,null,"2021-02-23"]
["2015-04-03","Långfredagen 2015",null,null,null,null,null,"2021-02-24"]
["2015-04-05","Påsk 2015",null,null,null,null,null,"2021-02-25"]
["2015-04-06","Annandag påsk 2015",null,null,null,null,null,"2021-02-26"]
["2015-05-01","Första maj 2015",null,null,null,null,null,"2021-02-27"]
["2015-05-14","Kristi Himmelsfärdsdag 2015",null,null,null,null,null,"2021-02-28"]
["2015-05-24","Pingstdagen 2015",null,null,null,null,null,"2021-03-01"]
["2015-05-25","Annandag pingst 2015",null,null,null,null,null,"2021-03-02"]
["2015-05-31","Mors dag 2015",null,null,null,null,null,"2021-03-03"]
["2015-06-06","Sveriges nationaldag 2015",null,null,null,null,null,"2021-03-04"]
["2015-06-19","Midsommarafton 2015",null,null,null,null,null,"2021-03-05"]
["2015-06-20","Midsommardagen 2015",null,null,null,null,null,"2021-03-06"]
["2015-10-25","Vintertid 2015",null,null,null,null,null,{"$f":"H68+1","v":"2021-03-07"}]
["2015-10-31","Halloween 2015",null,null,null,null,null,"2021-03-08"]
["2015-10-31","Alla helgons dag 2015",null,null,null,null,null,"2021-03-09"]
["2015-11-08","Fars dag 2015",null,null,null,null,null,"2021-03-10"]
["2015-12-13","Lucia 2015",null,null,null,null,null,"2021-03-11"]
["2015-12-24","Julafton 2015",null,null,null,null,null,"2021-03-12"]
["2015-12-25","Juldagen 2015",null,null,null,null,null,"2021-03-13"]
["2015-12-26","Annandag jul 2015",null,null,null,null,null,"2021-03-14"]
["2015-12-31","Nyårsafton 2015",null,null,null,null,null,"2021-03-15"]
["2016-01-01","Nyårsdagen 2016",null,null,null,null,null,"2021-03-16"]
["2016-01-06","Trettondedag jul 2016",null,null,null,null,null,"2021-03-17"]
["2016-02-14","Alla hjärtans dag 2016",null,null,null,null,null,"2021-03-18"]
["2016-03-24","Skärtorsdagen 2016",null,null,null,null,null,"2021-03-19"]
["2016-03-25","Långfredagen 2016",null,null,null,null,null,"2021-03-20"]
["2016-03-27","Påsk 2016",null,null,null,null,null,"2021-03-21"]
["2016-03-27","Sommartid 2016",null,null,null,null,null,"2021-03-22"]
["2016-03-28","Annandag påsk 2016",null,null,null,null,null,"2021-03-23"]
["2016-05-01","Första maj 2016",null,null,null,null,null,"2021-03-24"]
["2016-05-05","Kristi Himmelsfärdsdag 2016",null,null,null,null,null,"2021-03-25"]
["2016-05-15","Pingstdagen 2016",null,null,null,null,null,"2021-03-26"]
["2016-05-16","Annandag pingst 2016",null,null,null,null,null,"2021-03-27"]
["2016-05-29","Mors dag 2016",null,null,null,null,null,"2021-03-28"]
["2016-06-06","Sveriges nationaldag 2016",null,null,null,null,null,"2021-03-29"]
["2016-06-24","Midsommarafton 2016",null,null,null,null,null,"2021-03-30"]
["2016-06-25","Midsommardagen 2016",null,null,null,null,null,"2021-03-31"]
["2016-10-30","Vintertid 2016",null,null,null,null,null,"2021-04-01"]
["2016-10-31","Halloween 2016",null,null,null,null,null,"2021-04-02"]
["2016-11-05","Alla helgons dag 2016",null,null,null,null,null,"2021-04-03"]
["2016-11-13","Fars dag 2016",null,null,null,null,null,"2021-04-04"]
["2016-12-13","Lucia 2016",null,null,null,null,null,"2021-04-05"]
["2016-12-24","Julafton 2016",null,null,null,null,null,"2021-04-06"]
["2016-12-25","Juldagen 2016",null,null,null,null,null,"2021-04-07"]
["2016-12-26","Annandag jul 2016",null,null,null,null,null,"2021-04-08"]
["2016-12-31","Nyårsafton 2016",null,null,null,null,null,"2021-04-09"]
["2017-01-01","Nyårsdagen 2017",null,null,null,null,null,"2021-04-10"]
["2017-01-06","Trettondedag jul 2017",null,null,null,null,null,"2021-04-11"]
["2017-02-14","Alla hjärtans dag 2017",null,null,null,null,null,"2021-04-12"]
["2017-03-26","Sommartid 2017",null,null,null,null,null,"2021-04-13"]
["2017-04-13","Skärtorsdagen 2017",null,null,null,null,null,"2021-04-14"]
["2017-04-14","Långfredagen 2017",null,null,null,null,null,"2021-04-15"]
["2017-04-16","Påsk 2017",null,null,null,null,null,"2021-04-16"]
["2017-04-17","Annandag påsk 2017",null,null,null,null,null,"2021-04-17"]
["2017-05-01","Första maj 2017",null,null,null,null,null,"2021-04-18"]
["2017-05-25","Kristi Himmelsfärdsdag 2017",null,null,null,null,null,"2021-04-19"]
["2017-05-28","Mors dag 2017",null,null,null,null,null,"2021-04-20"]
["2017-06-04","Pingstdagen 2017",null,null,null,null,null,"2021-04-21"]
["2017-06-05","Annandag pingst 2017",null,null,null,null,null,"2021-04-22"]
["2017-06-06","Sveriges nationaldag 2017",null,null,null,null,null,"2021-04-23"]
["2017-06-23","Midsommarafton 2017",null,null,null,null,null,"2021-04-24"]
["2017-06-24","Midsommardagen 2017",null,null,null,null,null,"2021-04-25"]
["2017-10-29","Vintertid 2017",null,null,null,null,null,"2021-04-26"]
["2017-10-31","Halloween 2017",null,null,null,null,null,"2021-04-27"]
["2017-11-04","Alla helgons dag 2017",null,null,null,null,null,"2021-04-28"]
["2017-11-12","Fars dag 2017",null,null,null,null,null,"2021-04-29"]
["2017-12-13","Lucia 2017",null,null,null,null,null,"2021-04-30"]
["2017-12-24","Julafton 2017",null,null,null,null,null,"2021-05-01"]
["2017-12-25","Juldagen 2017",null,null,null,null,null,"2021-05-02"]
["2017-12-26","Annandag jul 2017",null,null,null,null,null,"2021-05-03"]
["2017-12-31","Nyårsafton 2017",null,null,null,null,null,"2021-05-04"]
["2018-01-01","Nyårsdagen 2018",null,null,null,null,null,"2021-05-05"]
["2018-01-06","Trettondedag jul 2018",null,null,null,null,null,"2021-05-06"]
["2018-02-14","Alla hjärtans dag 2018",null,null,null,null,null,"2021-05-07"]
["2018-03-25","Sommartid 2018",null,null,null,null,null,"2021-05-08"]
["2018-03-29","Skärtorsdagen 2018",null,null,null,null,null,"2021-05-09"]
["2018-03-30","Långfredagen 2018",null,null,null,null,null,{"$f":"H132+1","v":"2021-05-10"}]
["2018-04-01","Påsk 2018",null,null,null,null,null,"2021-05-11"]
["2018-04-02","Annandag påsk 2018",null,null,null,null,null,"2021-05-12"]
["2018-05-01","Första maj 2018",null,null,null,null,null,"2021-05-13"]
["2018-05-10","Kristi Himmelsfärdsdag 2018",null,null,null,null,null,"2021-05-14"]
["2018-05-20","Pingstdagen 2018",null,null,null,null,null,"2021-05-15"]
["2018-05-21","Annandag pingst 2018",null,null,null,null,null,"2021-05-16"]
["2018-05-27","Mors dag 2018",null,null,null,null,null,"2021-05-17"]
["2018-06-06","Sveriges nationaldag 2018",null,null,null,null,null,"2021-05-18"]
["2018-06-22","Midsommarafton 2018",null,null,null,null,null,"2021-05-19"]
["2018-06-23","Midsommardagen 2018",null,null,null,null,null,"2021-05-20"]
["2018-10-28","Vintertid 2018",null,null,null,null,null,"2021-05-21"]
["2018-10-31","Halloween 2018",null,null,null,null,null,"2021-05-22"]
["2018-11-03","Alla helgons dag 2018",null,null,null,null,null,"2021-05-23"]
["2018-11-11","Fars dag 2018",null,null,null,null,null,"2021-05-24"]
["2018-12-13","Lucia 2018",null,null,null,null,null,"2021-05-25"]
["2018-12-24","Julafton 2018",null,null,null,null,null,"2021-05-26"]
["2018-12-25","Juldagen 2018",null,null,null,null,null,"2021-05-27"]
["2018-12-26","Annandag jul 2018",null,null,null,null,null,"2021-05-28"]
["2018-12-31","Nyårsafton 2018",null,null,null,null,null,"2021-05-29"]
["2019-01-01","Nyårsdagen 2019",null,null,null,null,null,"2021-05-30"]
["2019-01-06","Trettondedag jul 2019",null,null,null,null,null,"2021-05-31"]
["2019-02-14","Alla hjärtans dag 2019",null,null,null,null,null,"2021-06-01"]
["2019-03-31","Sommartid 2019",null,null,null,null,null,"2021-06-02"]
["2019-04-18","Skärtorsdagen 2019",null,null,null,null,null,"2021-06-03"]
["2019-04-19","Långfredagen 2019",null,null,null,null,null,"2021-06-04"]
["2019-04-21","Påsk 2019",null,null,null,null,null,"2021-06-05"]
["2019-04-22","Annandag påsk 2019",null,null,null,null,null,"2021-06-06"]
["2019-05-01","Första maj 2019",null,null,null,null,null,"2021-06-07"]
["2019-05-26","Mors dag 2019",null,null,null,null,null,"2021-06-08"]
["2019-05-30","Kristi Himmelsfärdsdag 2019",null,null,null,null,null,"2021-06-09"]
["2019-06-06","Sveriges nationaldag 2019",null,null,null,null,null,"2021-06-10"]
["2019-06-09","Pingstdagen 2019",null,null,null,null,null,"2021-06-11"]
["2019-06-10","Annandag pingst 2019",null,null,null,null,null,"2021-06-12"]
["2019-06-21","Midsommarafton 2019",null,null,null,null,null,"2021-06-13"]
["2019-06-22","Midsommardagen 2019",null,null,null,null,null,"2021-06-14"]
["2019-10-27","Vintertid 2019",null,null,null,null,null,"2021-06-15"]
["2019-10-31","Halloween 2019",null,null,null,null,null,"2021-06-16"]
["2019-11-02","Alla helgons dag 2019",null,null,null,null,null,"2021-06-17"]
["2019-11-10","Fars dag 2019",null,null,null,null,null,"2021-06-18"]
["2019-12-13","Lucia 2019",null,null,null,null,null,"2021-06-19"]
["2019-12-24","Julafton 2019",null,null,null,null,null,"2021-06-20"]
["2019-12-25","Juldagen 2019",null,null,null,null,null,"2021-06-21"]
["2019-12-26","Annandag jul 2019",null,null,null,null,null,"2021-06-22"]
["2019-12-31","Nyårsafton 2019",null,null,null,null,null,"2021-06-23"]
["2020-01-01","Nyårsdagen 2020",null,null,null,null,null,"2021-06-24"]
["2020-01-06","Trettondedag jul 2020",null,null,null,null,null,"2021-06-25"]
["2020-02-14","Alla hjärtans dag 2020",null,null,null,null,null,"2021-06-26"]
["2020-03-29","Sommartid 2020",null,null,null,null,null,"2021-06-27"]
["2020-04-09","Skärtorsdagen 2020",null,null,null,null,null,"2021-06-28"]
["2020-04-10","Långfredagen 2020",null,null,null,null,null,"2021-06-29"]
["2020-04-12","Påsk 2020",null,null,null,null,null,"2021-06-30"]
["2020-04-13","Annandag påsk 2020",null,null,null,null,null,"2021-07-01"]
["2020-05-01","Första maj 2020",null,null,null,null,null,"2021-07-02"]
["2020-05-21","Kristi Himmelsfärdsdag 2020",null,null,null,null,null,"2021-07-03"]
["2020-05-31","Pingstdagen 2020",null,null,null,null,null,"2021-07-04"]
["2020-05-31","Mors dag 2020",null,null,null,null,null,"2021-07-05"]
["2020-06-01","Annandag pingst 2020",null,null,null,null,null,"2021-07-06"]
["2020-06-06","Sveriges nationaldag 2020",null,null,null,null,null,"2021-07-07"]
["2020-06-19","Midsommarafton 2020",null,null,null,null,null,"2021-07-08"]
["2020-06-20","Midsommardagen 2020",null,null,null,null,null,"2021-07-09"]
["2020-10-25","Vintertid 2020",null,null,null,null,null,"2021-07-10"]
["2020-10-31","Halloween 2020",null,null,null,null,null,"2021-07-11"]
["2020-10-31","Alla helgons dag 2020",null,null,null,null,null,"2021-07-12"]
["2020-11-08","Fars dag 2020",null,null,null,null,null,{"$f":"H196+1","v":"2021-07-13"}]
["2020-12-13","Lucia 2020",null,null,null,null,null,"2021-07-14"]
["2020-12-24","Julafton 2020",null,null,null,null,null,"2021-07-15"]
["2020-12-25","Juldagen 2020",null,null,null,null,null,"2021-07-16"]
["2020-12-26","Annandag jul 2020",null,null,null,null,null,"2021-07-17"]
["2020-12-31","Nyårsafton 2020",null,null,null,null,null,"2021-07-18"]
[null,null,null,null,null,null,null,"2021-07-19"]
[null,null,null,null,null,null,null,"2021-07-20"]
[null,null,null,null,null,null,null,"2021-07-21"]
[null,null,null,null,null,null,null,"2021-07-22"]
[null,null,null,null,null,null,null,"2021-07-23"]
[null,null,null,null,null,null,null,"2021-07-24"]
[null,null,null,null,null,null,null,"2021-07-25"]
[null,null,null,null,null,null,null,"2021-07-26"]
[null,null,null,null,null,null,null,"2021-07-27"]
[null,null,null,null,null,null,null,"2021-07-28"]
[null,null,null,null,null,null,null,"2021-07-29"]
[null,null,null,null,null,null,null,"2021-07-30"]
[null,null,null,null,null,null,null,"2021-07-31"]
[null,null,null,null,null,null,null,"2021-08-01"]
[null,null,null,null,null,null,null,"2021-08-02"]
[null,null,null,null,null,null,null,"2021-08-03"]
[null,null,null,null,null,null,null,"2021-08-04"]
[null,null,null,null,null,null,null,"2021-08-05"]
[null,null,null,null,null,null,null,"2021-08-06"]
[null,null,null,null,null,null,null,"2021-08-07"]
[null,null,null,null,null,null,null,"2021-08-08"]
[null,null,null,null,null,null,null,"2021-08-09"]
[null,null,null,null,null,null,null,"2021-08-10"]
[null,null,null,null,null,null,null,"2021-08-11"]
[null,null,null,null,null,null,null,"2021-08-12"]
[null,null,null,null,null,null,null,"2021-08-13"]
[null,null,null,null,null,null,null,"2021-08-14"]
[null,null,null,null,null,null,null,"2021-08-15"]
[null,null,null,null,null,null,null,"2021-08-16"]
[null,null,null,null,null,null,null,"2021-08-17"]
[null,null,null,null,null,null,null,"2021-08-18"]
[null,null,null,null,null,null,null,"2021-08-19"]
[null,null,null,null,null,null,null,"2021-08-20"]
[null,null,null,null,null,null,null,"2021-08-21"]
[null,null,null,null,null,null,null,"2021-08-22"]
[null,null,null,null,null,null,null,"2021-08-23"]
[null,null,null,null,null,null,null,"2021-08-24"]
[null,null,null,null,null,null,null,"2021-08-25"]
[null,null,null,null,null,null,null,"2021-08-26"]
[null,null,null,null,null,null,null,"2021-08-27"]
[null,null,null,null,null,null,null,"2021-08-28"]
[null,null,null,null,null,null,null,"2021-08-29"]
[null,null,null,null,null,null,null,"2021-08-30"]
[null,null,null,null,null,null,null,"2021-08-31"]
[null,null,null,null,null,null,null,"2021-09-01"]
[null,null,null,null,null,null,null,"2021-09-02"]
[null,null,null,null,null,null,null,"2021-09-03"]
[null,null,null,null,null,null,null,"2021-09-04"]
[null,null,null,null,null,null,null,"2021-09-05"]
[null,null,null,null,null,null,null,"2021-09-06"]
[null,null,null,null,null,null,null,"2021-09-07"]
[null,null,null,null,null,null,null,"2021-09-08"]
[null,null,null,null,null,null,null,"2021-09-09"]
[null,null,null,null,null,null,null,"2021-09-10"]
[null,null,null,null,null,null,null,"2021-09-11"]
[null,null,null,null,null,null,null,"2021-09-12"]
[null,null,null,null,null,null,null,"2021-09-13"]
[null,null,null,null,null,null,null,"2021-09-14"]
[null,null,null,null,null,null,null,{"$f":"H260+1","v":"2021-09-15"}]
[null,null,null,null,null,null,null,"2021-09-16"]
[null,null,null,null,null,null,null,"2021-09-17"]
[null,null,null,null,null,null,null,"2021-09-18"]
[null,null,null,null,null,null,null,"2021-09-19"]
[null,null,null,null,null,null,null,"2021-09-20"]
[null,null,null,null,null,null,null,"2021-09-21"]
[null,null,null,null,null,null,null,"2021-09-22"]
[null,null,null,null,null,null,null,"2021-09-23"]
[null,null,null,null,null,null,null,"2021-09-24"]
[null,null,null,null,null,null,null,"2021-09-25"]
[null,null,null,null,null,null,null,"2021-09-26"]
[null,null,null,null,null,null,null,"2021-09-27"]
[null,null,null,null,null,null,null,"2021-09-28"]
[null,null,null,null,null,null,null,"2021-09-29"]
[null,null,null,null,null,null,null,"2021-09-30"]
[null,null,null,null,null,null,null,"2021-10-01"]
[null,null,null,null,null,null,null,"2021-10-02"]
[null,null,null,null,null,null,null,"2021-10-03"]
[null,null,null,null,null,null,null,"2021-10-04"]
[null,null,null,null,null,null,null,"2021-10-05"]
[null,null,null,null,null,null,null,"2021-10-06"]
[null,null,null,null,null,null,null,"2021-10-07"]
[null,null,null,null,null,null,null,"2021-10-08"]
[null,null,null,null,null,null,null,"2021-10-09"]
[null,null,null,null,null,null,null,"2021-10-10"]
[null,null,null,null,null,null,null,"2021-10-11"]
[null,null,null,null,null,null,null,"2021-10-12"]
[null,null,null,null,null,null,null,"2021-10-13"]
[null,null,null,null,null,null,null,"2021-10-14"]
[null,null,null,null,null,null,null,"2021-10-15"]
[null,null,null,null,null,null,null,"2021-10-16"]
[null,null,null,null,null,null,null,"2021-10-17"]
[null,null,null,null,null,null,null,"2021-10-18"]
[null,null,null,null,null,null,null,"2021-10-19"]
[null,null,null,null,null,null,null,"2021-10-20"]
[null,null,null,null,null,null,null,"2021-10-21"]
[null,null,null,null,null,null,null,"2021-10-22"]
[null,null,null,null,null,null,null,"2021-10-23"]
[null,null,null,null,null,null,null,"2021-10-24"]
[null,null,null,null,null,null,null,"2021-10-25"]
[null,null,null,null,null,null,null,"2021-10-26"]
[null,null,null,null,null,null,null,"2021-10-27"]
[null,null,null,null,null,null,null,"2021-10-28"]
[null,null,null,null,null,null,null,"2021-10-29"]
[null,null,null,null,null,null,null,"2021-10-30"]
[null,null,null,null,null,null,null,"2021-10-31"]
[null,null,null,null,null,null,null,"2021-11-01"]
[null,null,null,null,null,null,null,"2021-11-02"]
[null,null,null,null,null,null,null,"2021-11-03"]
[null,null,null,null,null,null,null,"2021-11-04"]
[null,null,null,null,null,null,null,"2021-11-05"]
[null,null,null,null,null,null,null,"2021-11-06"]
[null,null,null,null,null,null,null,"2021-11-07"]
[null,null,null,null,null,null,null,"2021-11-08"]
[null,null,null,null,null,null,null,"2021-11-09"]
[null,null,null,null,null,null,null,"2021-11-10"]
[null,null,null,null,null,null,null,"2021-11-11"]
[null,null,null,null,null,null,null,"2021-11-12"]
[null,null,null,null,null,null,null,"2021-11-13"]
[null,null,null,null,null,null,null,"2021-11-14"]
[null,null,null,null,null,null,null,"2021-11-15"]
[null,null,null,null,null,null,null,"2021-11-16"]
[null,null,null,null,null,null,null,"2021-11-17"]
[null,null,null,null,null,null,null,{"$f":"H324+1","v":"2021-11-18"}]
[null,null,null,null,null,null,null,"2021-11-19"]
[null,null,null,null,null,null,null,"2021-11-20"]
[null,null,null,null,null,null,null,"2021-11-21"]
[null,null,null,null,null,null,null,"2021-11-22"]
[null,null,null,null,null,null,null,"2021-11-23"]
[null,null,null,null,null,null,null,"2021-11-24"]
[null,null,null,null,null,null,null,"2021-11-25"]
[null,null,null,null,null,null,null,"2021-11-26"]
[null,null,null,null,null,null,null,"2021-11-27"]
[null,null,null,null,null,null,null,"2021-11-28"]
[null,null,null,null,null,null,null,"2021-11-29"]
[null,null,null,null,null,null,null,"2021-11-30"]
[null,null,null,null,null,null,null,"2021-12-01"]
[null,null,null,null,null,null,null,"2021-12-02"]
[null,null,null,null,null,null,null,"2021-12-03"]
[null,null,null,null,null,null,null,"2021-12-04"]
[null,null,null,null,null,null,null,"2021-12-05"]
[null,null,null,null,null,null,null,"2021-12-06"]
[null,null,null,null,null,null,null,"2021-12-07"]
[null,null,null,null,null,null,null,"2021-12-08"]
[null,null,null,null,null,null,null,"2021-12-09"]
[null,null,null,null,null,null,null,"2021-12-10"]
[null,null,null,null,null,null,null,"2021-12-11"]
[null,null,null,null,null,null,null,"2021-12-12"]
[null,null,null,null,null,null,null,"2021-12-13"]
[null,null,null,null,null,null,null,"2021-12-14"]
[null,null,null,null,null,null,null,"2021-12-15"]
[null,null,null,null,null,null,null,"2021-12-16"]
[null,null,null,null,null,null,null,"2021-12-17"]
[null,null,null,null,null,null,null,"2021-12-18"]
[null,null,null,null,null,null,null,"2021-12-19"]
[null,null,null,null,null,null,null,"2021-12-20"]
[null,null,null,null,null,null,null,"2021-12-21"]
[null,null,null,null,null,null,null,"2021-12-22"]
[null,null,null,null,null,null,null,"2021-12-23"]
[null,null,null,null,null,null,null,"2021-12-24"]
[null,null,null,null,null,null,null,"2021-12-25"]
[null,null,null,null,null,null,null,"2021-12-26"]
[null,null,null,null,null,null,null,"2021-12-27"]
[null,null,null,null,null,null,null,"2021-12-28"]
[null,null,null,null,null,null,null,"2021-12-29"]
[null,null,null,null,null,null,null,"2021-12-30"]
[null,null,null,null,null,null,null,"2021-12-31"]
[null,null,null,null,null,null,null,"2022-01-01"]
[null,null,null,null,null,null,null,"2022-01-02"]

{"sheet":"date","index":2,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["DATE","DATUM"]
[null,null,{"$f":"DATE(D2,E2,F2)","v":"2017-03-13"},2017,3,13]
[]
["YEAR","ÅR",{"$f":"YEAR(C2)","v":2017}]
["MONTH","MÅNAD",{"$f":"MONTH(C2)","v":3}]
["DAY","DAG",{"$f":"DAY(C2)","v":13}]

{"sheet":"datedif","index":3,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["datedif","datedif","Y","m","d","md","ym","d"]
["1961-12-15",{"$f":"TODAY()","v":"2021-01-08"},{"$f":"DATEDIF(A2:A6,B2:B6,C1:H1)","v":59},708,21574,24,0,21574]
["1970-01-01","2021-01-08",51,612,18635,7,0,18635]
["2028-12-24","2021-01-08",{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[{"$f":"TODAY()-15","v":"2020-12-24"},"2021-01-08",0,0,15,15,0,15]
[{"$f":"EDATE(B6,-2)","v":"2020-11-08"},"2021-01-08",0,2,61,0,2,61]
[]
[null,"complete","year","months","days"]
[null,"ignore",null,null,null,"month and year","days and years","years"]
[null," "]
[]
[]
[null,null,"Excel can do anything for you, but you have to give instructions!"]
[null,null,"Karpagam Excel"]
[]
[]
[null,null," "]

{"sheet":"Mac","index":4,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["1975-11-05",{"$f":"TEXT(A1,\"0\")","v":"27703"},{"$f":"_xlfn.FORMULATEXT(B1)","v":"=TEXT(A1;\"0\")"}]
["1999-12-31",{"$f":"TEXT(A2,\"0\")","v":"36525"},{"$f":"_xlfn.FORMULATEXT(B2)","v":"=TEXT(A2;\"0\")"}]
[]
[null,{"$f":"YEAR(1)","v":1900},{"$f":"_xlfn.FORMULATEXT(B4)","v":"=YEAR(1)"}]
[null,{"$f":"IF(YEAR(1)=1900,\"Lotus\",\"Macintosh\")","v":"Lotus"},{"$f":"_xlfn.FORMULATEXT(B5)","v":"=IF(YEAR(1)=1900;\"Lotus\";\"Macintosh\")"}]
[]
[]
[]
[]
[]
[]
[]
["#N/A"]
["Unix bases its time values on the number of seconds since midnight (00:00:00) on 1 January 1970"]
[null,{"$f":"IF(YEAR(1)=1970,\"Unix\",\"Excel date\")","v":"Excel date"},{"$f":"_xlfn.FORMULATEXT(B15)","v":"=IF(YEAR(1)=1970;\"Unix\";\"Excel date\")"}]
[]
["Excel date",{"$f":"NOW()","v":"2021-01-08T08:25:48.330"},{"$f":"_xlfn.FORMULATEXT(B17)","v":"=NOW()"}]
["Unix date",{"$f":"(B17-DATE(1970,1,1))*24*60*60","v":1610094348.3299997},{"$f":"_xlfn.FORMULATEXT(B18)","v":"=(B17-DATE(1970;1;1))*24*60*60"}]
["Excel date",{"$f":"DATE(1970,1,1)+B18/24/60/60","v":"2021-01-08T08:25:48.330"},{"$f":"_xlfn.FORMULATEXT(B19)","v":"=DATE(1970;1;1)+B18/24/60/60"}]
[]
["Unix dead line",{"$f":"2^31","v":2147483648},{"$f":"_xlfn.FORMULATEXT(B21)","v":"=2^31"}]
["Excel date",{"$f":"DATE(1970,1,1)+B21/24/60/60","v":"2038-01-19T03:14:08"},{"$f":"_xlfn.FORMULATEXT(B22)","v":"=DATE(1970;1;1)+B21/24/60/60"}]
[]
["A bit more time",{"$f":"2^32","v":4294967296},{"$f":"_xlfn.FORMULATEXT(B24)","v":"=2^32"}]
["Excel date",{"$f":"DATE(1970,1,1)+B24/24/60/60","v":"2106-02-07T06:28:16"},{"$f":"_xlfn.FORMULATEXT(B25)","v":"=DATE(1970;1;1)+B24/24/60/60"}]
[]
["What is the unix time stamp?"]
["The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC. Therefore, the unix time stamp is merely the number of seconds between a particular date and the Unix Epoch. It should also be pointed out (thanks to the comments from visitors to this site) that this point in time technically does not change no matter where you are located on the globe. This is very useful to computer systems for tracking and sorting dated information in dynamic and distributed applications both online and client side."]
["What happens on January 19, 2038?"]
[]
["On this date the Unix Time Stamp will cease to work due to a 32-bit overflow. Before this moment millions of applications will need to either adopt a new convention for time stamps or be migrated to 64-bit systems which will buy the time stamp a \"bit\" more time. "]
[]
["Excel dead line",2958465]
["Excel date",{"$f":"B33","v":"9999-12-31"}]
[]
[]
[]
["Outlook saknar 29 feb 1900. Excel har det som dag 60 för att vara kompatibel med Lotus."]

{"sheet":"edate","index":5,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["EDATE","EDATUM"]
["NOW","NU",{"$f":"NOW()","v":"2021-01-08T08:25:48.330"}]
[null,null,{"$f":"EDATE($C$2,-1)","v":"2020-12-08"},"Föregående månad"]
[null,null,{"$f":"EDATE($C$2,-4*12)","v":"2017-01-08"},"4 år sedan (inkl skottår)"]
[null,null,{"$f":"$C$2-DAY($C$2)","v":"2020-12-31T08:25:48.330"},"Föregående månads sista dag"]
[null,null,{"$f":"EDATE($C$2,1)-DAY(EDATE($C$2,1))","v":"2021-01-31"},"Månadens sista dag"]
[null,null,{"$f":"EDATE($C$2,2)-DAY(EDATE($C$2,2))","v":"2021-02-28"},"Nästa månads sista dag"]

{"sheet":"weeknum","index":6,"n_rows":55,"n_cols":3,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Veckonummer"]
["Formel","Resultat","Kommentar (hitta förra veckans nr)"]
[{"$f":"_xlfn.FORMULATEXT(B3)","v":{"$error":"#N/A"}},"2016-01-01","Idag"]
["=WEEKDAY($B$3)",{"$f":"WEEKDAY($B$3)","v":6},"Veckodagsnumret utgår från söndag = 1"]
["=$B$3-WEEKDAY($B$3)",{"$f":"$B$3-WEEKDAY($B$3)","v":"2015-12-26"},"Minus veckodagsnumret ger alltid en lördag"]
["=$B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7",{"$f":"$B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7","v":"2015-12-26"},"Om vi börjar på en söndag så hamnar vi på innevarande veckas lördag. Backa isf en vecka"]
["=$B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5",{"$f":"$B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5","v":"2015-12-31"},"Lägg till fem dagar så har vi alltid veckans torsdag"]
["=WEEKNUM($B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5;21)",{"$f":"WEEKNUM($B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5,21)","v":53}]
["=\"W\" &\nMID(TEXT(YEAR($B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5);\"0000\");3;2)  &\nTEXT(WEEKNUM($B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5;21);\"00\")",{"$f":"\"W\" &\nMID(TEXT(YEAR($B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5),\"0000\"),3,2)  &\nTEXT(WEEKNUM($B$3-WEEKDAY($B$3)-N(WEEKDAY($B$3)=1)*7+5,21),\"00\")","v":"W1553"},"Veckonr inkl år av veckans torsdag"]
["=ISOWEEKNUM(B3)",{"$f":"_xlfn.ISOWEEKNUM(B3)","v":53},"Inbyggd funktion. Hanterar ej årtal som prefix. Prekärt vid årsskifte"]
["Vecka - 1",{"$f":"WEEKNUM($A$9-1*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7,21)","v":{"$error":"#VALUE!"}},{"$f":"YEAR($A$9-7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7)","v":{"$error":"#VALUE!"}}]
["Vecka - 2",{"$f":"WEEKNUM($A$9-2*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7,21)","v":{"$error":"#VALUE!"}},{"$f":"YEAR($A$9-7*2-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7)","v":{"$error":"#VALUE!"}}]
["Vecka - 8 -- 1",{"$f":"TEXT(YEAR($A$9-8*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7)*100+WEEKNUM($A$9-8*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7,21),\"0000\")&\"-\"&TEXT(YEAR($A$9-1*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7)*100+WEEKNUM($A$9-1*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7,21),\"0000\")","v":{"$error":"#VALUE!"}}]
["Vecka - 9 -- 2",{"$f":"TEXT(YEAR($A$9-9*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7)*100+WEEKNUM($A$9-9*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7,21),\"0000\")&\"-\"&TEXT(YEAR($A$9-2*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7)*100+WEEKNUM($A$9-2*7-WEEKDAY($A$9)+5-N(WEEKDAY($A$9)=1)*7,21),\"0000\")","v":{"$error":"#VALUE!"}}]
[]
[]
["Veckonr nu:",{"$f":"\"W\" &  MID(TEXT(YEAR(A21+A22+0*7-WEEKDAY(A21+A22+0*7)+5-N(WEEKDAY(A21+A22)=1)*7),\"0000\"),3,2) & TEXT(WEEKNUM(A21+A22+0*7-WEEKDAY(A21+A22+0*7)+5-N(WEEKDAY(A21+A22)=1)*7,21),\"00\")","v":"W2101"},"Arkiv: Alternativ: Språkkontroll: Alternativ för språkkontroll… och lägg till eg vnr med formeln som \"ersätt med\""]
[]
[]
[]
[{"$f":"NOW()","v":"2021-01-08T08:25:48.330"}]
[0,{"$f":"\"Week \" &  MID(TEXT(YEAR(A21+A22+0*7-WEEKDAY(A21+A22+0*7)+5-N(WEEKDAY(A21+A22)=1)*7),\"0000\"),3,2) & TEXT(WEEKNUM(A21+A22+0*7-WEEKDAY(A21+A22+0*7)+5-N(WEEKDAY(A21+A22)=1)*7,21),\"00\")","v":"Week 2101"},{"$f":"A21+A22","v":"2021-01-08T08:25:48.330"}]
[0,{"$f":"\"Week \" &  MID(TEXT(YEAR(A21+A22+A23*7-WEEKDAY(A21+A22+A23*7)+5-N(WEEKDAY(A21+A22)=1)*7),\"0000\"),3,2) & TEXT(WEEKNUM(A21+A22+A23*7-WEEKDAY(A21+A22+A23*7)+5-N(WEEKDAY(A21+A22)=1)*7,21),\"00\")","v":"Week 2101"},{"$f":"A21+A22+7*A23","v":"2021-01-08T08:25:48.330"}]
[]
[]
[null,"Hitta veckans torsdag"]
[{"$f":"NOW()+8-ROWS($1:1)","v":"2021-01-15T08:25:48.330"},{"$f":"A27-WEEKDAY(A27)+5-N(WEEKDAY(A27)=1)*7","v":"2021-01-14T08:25:48.330"}]
[{"$f":"NOW()+8-ROWS($1:2)","v":"2021-01-14T08:25:48.330"},"2021-01-14T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:3)","v":"2021-01-13T08:25:48.330"},"2021-01-14T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:3)","v":"2021-01-13T08:25:48.330"},"2021-01-14T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:4)","v":"2021-01-12T08:25:48.330"},"2021-01-14T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:5)","v":"2021-01-11T08:25:48.330"},"2021-01-14T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:7)","v":"2021-01-09T08:25:48.330"},"2021-01-07T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:7)","v":"2021-01-09T08:25:48.330"},"2021-01-07T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:8)","v":"2021-01-08T08:25:48.330"},"2021-01-07T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:9)","v":"2021-01-07T08:25:48.330"},"2021-01-07T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:10)","v":"2021-01-06T08:25:48.330"},"2021-01-07T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:11)","v":"2021-01-05T08:25:48.330"},"2021-01-07T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:12)","v":"2021-01-04T08:25:48.330"},"2021-01-07T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:13)","v":"2021-01-03T08:25:48.330"},"2020-12-31T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:14)","v":"2021-01-02T08:25:48.330"},"2020-12-31T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:15)","v":"2021-01-01T08:25:48.330"},"2020-12-31T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:16)","v":"2020-12-31T08:25:48.330"},"2020-12-31T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:17)","v":"2020-12-30T08:25:48.330"},"2020-12-31T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:18)","v":"2020-12-29T08:25:48.330"},"2020-12-31T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:19)","v":"2020-12-28T08:25:48.330"},"2020-12-31T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:20)","v":"2020-12-27T08:25:48.330"},"2020-12-24T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:21)","v":"2020-12-26T08:25:48.330"},"2020-12-24T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:22)","v":"2020-12-25T08:25:48.330"},"2020-12-24T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:23)","v":"2020-12-24T08:25:48.330"},"2020-12-24T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:24)","v":"2020-12-23T08:25:48.330"},"2020-12-24T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:25)","v":"2020-12-22T08:25:48.330"},"2020-12-24T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:26)","v":"2020-12-21T08:25:48.330"},"2020-12-24T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:27)","v":"2020-12-20T08:25:48.330"},"2020-12-17T08:25:48.330"]
[{"$f":"NOW()+8-ROWS($1:28)","v":"2020-12-19T08:25:48.330"},"2020-12-17T08:25:48.330"]

{"sheet":"weekNum2date","index":7,"n_rows":41,"n_cols":26,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[{"$f":"L1","v":"WeekNum"},{"$f":"T1","v":"WeekNum Sunday"},null,null,null,null,"Date","Weekday","Dates Thursday","WeekNum .se",null,"WeekNum","1/1 Thursday","Years first Thursday","WeekNum Thursday",null,"WeekNum Sunday",null,null,"WeekNum Sunday",null,"Excel","Qlik",null,null,{"$f":"AK1","v":0}]
[{"$f":"_xlfn.UNIQUE(_xlfn.ANCHORARRAY(S2):_xlfn.ANCHORARRAY(T2))","v":2050},"2020-12-13",null,null,null,null,{"$f":"_xlfn.SEQUENCE(40,,TODAY()-30)","v":"2020-12-09"},{"$f":"WEEKDAY(_xlfn.ANCHORARRAY($G2))","v":4},{"$f":"_xlfn.ANCHORARRAY($G2)-WEEKDAY(_xlfn.ANCHORARRAY($G2))-IF(WEEKDAY(_xlfn.ANCHORARRAY($G2))=1,7,0)+5","v":"2020-12-10"},{"$f":"(YEAR($G2-WEEKDAY($G2)-IF(WEEKDAY($G2)=1,7,0)+5)-2000)*100+WEEKNUM($G2,21)","v":2050},null,{"$f":"J2:J41","v":2050},{"$f":"DATEVALUE(2000 +  INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\")-WEEKDAY(DATEVALUE(2000 +  INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\"))-IF(WEEKDAY(DATEVALUE(2000 +  INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\"))=1,7,0)+5","v":"2020-01-02"},{"$f":"_xlfn.ANCHORARRAY(M2)+IF(YEAR(_xlfn.ANCHORARRAY(M2))=2000 +  INT(_xlfn.ANCHORARRAY($L2)/100),0,7)","v":"2020-01-02"},{"$f":"_xlfn.ANCHORARRAY($N2)+ROUND((_xlfn.ANCHORARRAY($L2)/100-INT(_xlfn.ANCHORARRAY($L2)/100))*100-1,0)*7","v":"2020-12-10"},null,{"$f":"_xlfn.ANCHORARRAY($N2)+ROUND((_xlfn.ANCHORARRAY($L2)/100-INT(_xlfn.ANCHORARRAY($L2)/100))*100-1,0)*7+3","v":"2020-12-13"},null,{"$f":"_xlfn.ANCHORARRAY(L2)","v":2050},{"$f":"(DATEVALUE(2000 + INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\")-WEEKDAY(DATEVALUE(2000 + INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\"))-IF(WEEKDAY(DATEVALUE(2000 + INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\"))>1,0,7)+5+IF(YEAR(DATEVALUE(2000 + INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\")-WEEKDAY(DATEVALUE(2000 + INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\"))-IF(WEEKDAY(DATEVALUE(2000 + INT(_xlfn.ANCHORARRAY($L2)/100) & \"-01-01\"))>1,0,7)+5)=2000 + INT(_xlfn.ANCHORARRAY($L2)/100),0,7)+ROUND((_xlfn.ANCHORARRAY($L2)/100-INT(_xlfn.ANCHORARRAY($L2)/100))*100-1,0)*7+3)","v":"2020-12-13"},null,"DATEVALUE","date#",null,null,{"$f":"A2","v":2050}]
[2051,"2020-12-20",null,null,null,null,"2020-12-10",5,"2020-12-10",2050,null,2050,"2020-01-02","2020-01-02","2020-12-10",null,"2020-12-13",null,2050,"2020-12-13",null,"INT","floor"]
[2052,"2020-12-27",null,null,null,null,"2020-12-11",6,"2020-12-10",2050,null,2050,"2020-01-02","2020-01-02","2020-12-10",null,"2020-12-13",null,2050,"2020-12-13",null,"WEEKDAY","weekDay"]
[2053,"2021-01-03",null,null,null,null,"2020-12-12",7,"2020-12-10",2050,null,2050,"2020-01-02","2020-01-02","2020-12-10",null,"2020-12-13",null,2050,"2020-12-13",null,"IF","if"]
[2101,"2021-01-10",null,null,null,null,"2020-12-13",1,"2020-12-10",2050,null,2050,"2020-01-02","2020-01-02","2020-12-10",null,"2020-12-13",null,2050,"2020-12-13",null,"YEAR","year"]
[2102,"2021-01-17",null,null,null,null,"2020-12-14",2,"2020-12-17",2051,null,2051,"2020-01-02","2020-01-02","2020-12-17",null,"2020-12-20",null,2051,"2020-12-20",null,"ROUND","round"]
[null,null,null,null,null,null,"2020-12-15",3,"2020-12-17",2051,null,2051,"2020-01-02","2020-01-02","2020-12-17",null,"2020-12-20",null,2051,"2020-12-20",null,";0)",")"]
[null,null,null,null,null,null,"2020-12-16",4,"2020-12-17",2051,null,2051,"2020-01-02","2020-01-02","2020-12-17",null,"2020-12-20",null,2051,"2020-12-20",null,";",","]
[null,null,null,null,null,null,"2020-12-17",5,"2020-12-17",2051,null,2051,"2020-01-02","2020-01-02","2020-12-17",null,"2020-12-20",null,2051,"2020-12-20",null,"\"","'"]
[null,null,null,null,null,null,"2020-12-18",6,"2020-12-17",2051,null,2051,"2020-01-02","2020-01-02","2020-12-17",null,"2020-12-20",null,2051,"2020-12-20",null,"$L2#","[WeekNum]"]
[null,null,null,null,null,null,"2020-12-19",7,"2020-12-17",2051,null,2051,"2020-01-02","2020-01-02","2020-12-17",null,"2020-12-20",null,2051,"2020-12-20",null,"$L2#","$(fooWekNum)"]
[null,null,null,null,null,null,"2020-12-20",1,"2020-12-17",2051,null,2051,"2020-01-02","2020-01-02","2020-12-17",null,"2020-12-20",null,2051,"2020-12-20"]
[null,null,null,null,null,null,"2020-12-21",2,"2020-12-24",2052,null,2052,"2020-01-02","2020-01-02","2020-12-24",null,"2020-12-27",null,2052,"2020-12-27"]
[null,null,null,null,null,null,"2020-12-22",3,"2020-12-24",2052,null,2052,"2020-01-02","2020-01-02","2020-12-24",null,"2020-12-27",null,2052,"2020-12-27"]
[null,null,null,null,null,null,"2020-12-23",4,"2020-12-24",2052,null,2052,"2020-01-02","2020-01-02","2020-12-24",null,"2020-12-27",null,2052,"2020-12-27"]
[null,null,null,null,null,null,"2020-12-24",5,"2020-12-24",2052,null,2052,"2020-01-02","2020-01-02","2020-12-24",null,"2020-12-27",null,2052,"2020-12-27"]
[null,null,null,null,null,null,"2020-12-25",6,"2020-12-24",2052,null,2052,"2020-01-02","2020-01-02","2020-12-24",null,"2020-12-27",null,2052,"2020-12-27"]
[null,null,null,null,null,null,"2020-12-26",7,"2020-12-24",2052,null,2052,"2020-01-02","2020-01-02","2020-12-24",null,"2020-12-27",null,2052,"2020-12-27",null,{"$f":"TRANSPOSE(Table1[#Headers])","v":"Excel"},{"$f":"_xlfn.FORMULATEXT(T2)","v":"=(DATEVALUE(2000 + INT($L2#/100) & \"-01-01\")-WEEKDAY(DATEVALUE(2000 + INT($L2#/100) & \"-01-01\"))-IF(WEEKDAY(DATEVALUE(2000 + INT($L2#/100) & \"-01-01\"))>1;0;7)+5+IF(YEAR(DATEVALUE(2000 + INT($L2#/100) & \"-01-01\")-WEEKDAY(DATEVALUE(2000 + INT($L2#/100) & \"-01-01\"))-IF(WEEKDAY(DATEVALUE(2000 + INT($L2#/100) & \"-01-01\"))>1;0;7)+5)=2000 + INT($L2#/100);0;7)+ROUND(($L2#/100-INT($L2#/100))*100-1;0)*7+3)"}]
[null,null,null,null,null,null,"2020-12-27",1,"2020-12-24",2052,null,2052,"2020-01-02","2020-01-02","2020-12-24",null,"2020-12-27",null,2052,"2020-12-27",null,"Qlik",{"$f":"translateFormula(W19,Table1[])","v":"=(date#(2000 + floor([WeekNum]/100) & '-01-01')-weekDay(date#(2000 + floor([WeekNum]/100) & '-01-01'))-if(weekDay(date#(2000 + floor([WeekNum]/100) & '-01-01'))>1,0,7)+5+if(year(date#(2000 + floor([WeekNum]/100) & '-01-01')-weekDay(date#(2000 + floor([WeekNum]/100) & '-01-01'))-if(weekDay(date#(2000 + floor([WeekNum]/100) & '-01-01'))>1,0,7)+5)=2000 + floor([WeekNum]/100),0,7)+round(([WeekNum]/100-floor([WeekNum]/100))*100-1)*7+3)"}]
[null,null,null,null,null,null,"2020-12-28",2,"2020-12-31",2053,null,2053,"2020-01-02","2020-01-02","2020-12-31",null,"2021-01-03",null,2053,"2021-01-03"]
[null,null,null,null,null,null,"2020-12-29",3,"2020-12-31",2053,null,2053,"2020-01-02","2020-01-02","2020-12-31",null,"2021-01-03",null,2053,"2021-01-03"]
[null,null,null,null,null,null,"2020-12-30",4,"2020-12-31",2053,null,2053,"2020-01-02","2020-01-02","2020-12-31",null,"2021-01-03",null,2053,"2021-01-03"]
[null,null,null,null,null,null,"2020-12-31",5,"2020-12-31",2053,null,2053,"2020-01-02","2020-01-02","2020-12-31",null,"2021-01-03",null,2053,"2021-01-03"]
[null,null,null,null,null,null,"2021-01-01",6,"2020-12-31",2053,null,2053,"2020-01-02","2020-01-02","2020-12-31",null,"2021-01-03",null,2053,"2021-01-03"]
[null,null,null,null,null,null,"2021-01-02",7,"2020-12-31",2053,null,2053,"2020-01-02","2020-01-02","2020-12-31",null,"2021-01-03",null,2053,"2021-01-03"]
[null,null,null,null,null,null,"2021-01-03",1,"2020-12-31",2053,null,2053,"2020-01-02","2020-01-02","2020-12-31",null,"2021-01-03",null,2053,"2021-01-03"]
[null,null,null,null,null,null,"2021-01-04",2,"2021-01-07",2101,null,2101,"2020-12-31","2021-01-07","2021-01-07",null,"2021-01-10",null,2101,"2021-01-10"]
[null,null,null,null,null,null,"2021-01-05",3,"2021-01-07",2101,null,2101,"2020-12-31","2021-01-07","2021-01-07",null,"2021-01-10",null,2101,"2021-01-10"]
[null,null,null,null,null,null,"2021-01-06",4,"2021-01-07",2101,null,2101,"2020-12-31","2021-01-07","2021-01-07",null,"2021-01-10",null,2101,"2021-01-10"]
[null,null,null,null,null,null,"2021-01-07",5,"2021-01-07",2101,null,2101,"2020-12-31","2021-01-07","2021-01-07",null,"2021-01-10",null,2101,"2021-01-10"]
[null,null,null,null,null,null,"2021-01-08",6,"2021-01-07",2101,null,2101,"2020-12-31","2021-01-07","2021-01-07",null,"2021-01-10",null,2101,"2021-01-10"]
[null,null,null,null,null,null,"2021-01-09",7,"2021-01-07",2101,null,2101,"2020-12-31","2021-01-07","2021-01-07",null,"2021-01-10",null,2101,"2021-01-10"]
[null,null,null,null,null,null,"2021-01-10",1,"2021-01-07",2101,null,2101,"2020-12-31","2021-01-07","2021-01-07",null,"2021-01-10",null,2101,"2021-01-10"]
[null,null,null,null,null,null,"2021-01-11",2,"2021-01-14",2102,null,2102,"2020-12-31","2021-01-07","2021-01-14",null,"2021-01-17",null,2102,"2021-01-17"]
[null,null,null,null,null,null,"2021-01-12",3,"2021-01-14",2102,null,2102,"2020-12-31","2021-01-07","2021-01-14",null,"2021-01-17",null,2102,"2021-01-17"]
[null,null,null,null,null,null,"2021-01-13",4,"2021-01-14",2102,null,2102,"2020-12-31","2021-01-07","2021-01-14",null,"2021-01-17",null,2102,"2021-01-17"]
[null,null,null,null,null,null,"2021-01-14",5,"2021-01-14",2102,null,2102,"2020-12-31","2021-01-07","2021-01-14",null,"2021-01-17",null,2102,"2021-01-17"]
[null,null,null,null,null,null,"2021-01-15",6,"2021-01-14",2102,null,2102,"2020-12-31","2021-01-07","2021-01-14",null,"2021-01-17",null,2102,"2021-01-17"]
[null,null,null,null,null,null,"2021-01-16",7,"2021-01-14",2102,null,2102,"2020-12-31","2021-01-07","2021-01-14",null,"2021-01-17",null,2102,"2021-01-17"]
[null,null,null,null,null,null,"2021-01-17",1,"2021-01-14",2102,null,2102,"2020-12-31","2021-01-07","2021-01-14",null,"2021-01-17",null,2102,"2021-01-17"]

{"sheet":"Lotus Day","index":8,"n_rows":73,"n_cols":5,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["1900-01-01"]
["1900-01-02"]
["1900-01-03"]
["1900-01-04"]
["1900-01-05"]
["1900-01-06"]
["1900-01-07"]
["1900-01-08"]
["1900-01-09"]
["1900-01-10"]
["1900-01-11"]
["1900-01-12"]
["1900-01-13"]
["1900-01-14"]
["1900-01-15"]
["1900-01-16"]
["1900-01-17"]
["1900-01-18"]
["1900-01-19"]
["1900-01-20"]
["1900-01-21"]
["1900-01-22"]
["1900-01-23"]
["1900-01-24"]
["1900-01-25"]
["1900-01-26"]
["1900-01-27"]
["1900-01-28"]
["1900-01-29"]
["1900-01-30"]
["1900-01-31"]
["1900-02-01"]
["1900-02-02"]
["1900-02-03"]
["1900-02-04"]
["1900-02-05"]
["1900-02-06"]
["1900-02-07"]
["1900-02-08"]
["1900-02-09"]
["1900-02-10"]
["1900-02-11"]
["1900-02-12"]
["1900-02-13"]
["1900-02-14"]
["1900-02-15"]
["1900-02-16"]
["1900-02-17"]
["1900-02-18"]
["1900-02-19"]
["1900-02-20"]
["1900-02-21"]
["1900-02-22"]
["1900-02-23"]
["1900-02-24"]
["1900-02-25"]
["1900-02-26"]
["1900-02-27"]
["1900-02-28"]
[60,"This date is not possible",null,null,"Outlook saknar 29 feb 1900. Excel har det som dag 60 för att vara kompatibel med Lotus. Jan och Feb 1900 är följaktligen en dag fel jämfört med verklig kalender."]
["1900-03-01"]
["1900-03-02"]
["1900-03-03"]
["1900-03-04"]
["1900-03-05"]
["1900-03-06"]
["1900-03-07"]
["1900-03-08"]
["1900-03-09"]
["1900-03-10"]
["1900-03-11"]
["1900-03-12"]
["1900-03-13"]