{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["daily",null,"weekly",null,null,"monthly",null,null,"quaterly",null,null,"halfyearly",null,null,"yearly"]
[]
["2013-01-01",null,{"$f":"findfriday($A$3,ROW($A1)-1,C$1)","v":"2012-12-28"},{"$f":"findfriday($A$3,ROW($A1),C$1)-1","v":"2013-01-03"},null,{"$f":"findfriday($A$3,ROW($A1)-1,F$1)","v":"2012-12-28"},{"$f":"findfriday($A$3,ROW($A1),F$1)-1","v":"2013-01-31"},null,{"$f":"findfriday($A$3,ROW($A1)-1,I$1)","v":"2012-12-28"},{"$f":"findfriday($A$3,ROW($A1),I$1)-1","v":"2013-03-28"},null,{"$f":"findfriday($A$3,ROW($A1)-1,L$1)","v":"2012-12-28"},{"$f":"findfriday($A$3,ROW($A1),L$1)-1","v":"2013-06-27"},null,{"$f":"findfriday($A$3,ROW($A1)-1,O$1)","v":"2012-12-28"},{"$f":"findfriday($A$3,ROW($A1),O$1)-1","v":"2013-12-26"}]
["2013-01-02",null,{"$f":"findfriday($A$3,ROW(A2)-1,C$1)","v":"2013-01-04"},{"$f":"findfriday($A$3,ROW($A2),C$1)-1","v":"2013-01-10"},null,{"$f":"findfriday($A$3,ROW(D2)-1,F$1)","v":"2013-02-01"},{"$f":"findfriday($A$3,ROW($A2),F$1)-1","v":"2013-02-28"},null,{"$f":"findfriday($A$3,ROW(G2)-1,I$1)","v":"2013-03-29"},{"$f":"findfriday($A$3,ROW($A2),I$1)-1","v":"2013-06-27"},null,{"$f":"findfriday($A$3,ROW(J2)-1,L$1)","v":"2013-06-28"},{"$f":"findfriday($A$3,ROW($A2),L$1)-1","v":"2013-12-26"},null,{"$f":"findfriday($A$3,ROW(M2)-1,O$1)","v":"2013-12-27"},{"$f":"findfriday($A$3,ROW($A2),O$1)-1","v":"2014-12-25"}]
["2013-01-03",null,{"$f":"findfriday($A$3,ROW(A3)-1,C$1)","v":"2013-01-11"},"2013-01-17",null,{"$f":"findfriday($A$3,ROW(D3)-1,F$1)","v":"2013-03-01"},{"$f":"findfriday($A$3,ROW($A3),F$1)-1","v":"2013-03-28"},null,{"$f":"findfriday($A$3,ROW(G3)-1,I$1)","v":"2013-06-28"},"2013-09-26",null,{"$f":"findfriday($A$3,ROW(J3)-1,L$1)","v":"2013-12-27"},"2014-06-26",null,{"$f":"findfriday($A$3,ROW(M3)-1,O$1)","v":"2014-12-26"},"2015-12-31"]
["2013-01-04",null,{"$f":"findfriday($A$3,ROW(A4)-1,C$1)","v":"2013-01-18"},"2013-01-24",null,"2013-03-29","2013-04-25",null,"2013-09-27","2013-12-26",null,{"$f":"findfriday($A$3,ROW(J4)-1,L$1)","v":"2014-06-27"},"2014-12-25",null,{"$f":"findfriday($A$3,ROW(M4)-1,O$1)","v":"2016-01-01"},"2016-12-29"]
["2013-01-05",null,"2013-01-25","2013-01-31",null,{"$f":"findfriday($A$3,ROW(D5)-1,F$1)","v":"2013-04-26"},"2013-05-30",null,"2013-12-27","2014-03-27",null,"2014-12-26","2015-06-25",null,"2016-12-30","2017-12-28"]
["2013-01-06",null,"2013-02-01",{"$f":"findfriday($A$3,ROW($A6),C$1)-1","v":"2013-02-07"},null,{"$f":"findfriday($A$3,ROW(D6)-1,F$1)","v":"2013-05-31"},"2013-06-27",null,"2014-03-28","2014-06-26",null,"2015-06-26","2015-12-31",null,"2017-12-29","2018-12-27"]
["2013-01-07",null,"2013-02-08","2013-02-14",null,{"$f":"findfriday($A$3,ROW(D7)-1,F$1)","v":"2013-06-28"},"2013-07-25",null,"2014-06-27",{"$f":"findfriday($A$3,ROW($A7),I$1)-1","v":"2014-09-25"},null,"2016-01-01","2016-06-30",null,"2018-12-28","2019-12-26"]
["2013-01-08",null,"2013-02-15","2013-02-21",null,{"$f":"findfriday($A$3,ROW(D8)-1,F$1)","v":"2013-07-26"},"2013-08-29",null,"2014-09-26","2014-12-25",null,"2016-07-01","2016-12-29",null,"2019-12-27","2020-12-31"]
[]
[]
[]
[null,null,"HI experts,"]
[null,null,"Pls help me solve a query"]
[null,null,"above are the dates daily, weekly (Monday to Sunday), monthly (1st to 31 st), quarterly from 1st jan to 31st march and so on…"]
[null,null,"I want is week to start from Friday to Thursday"]
[null,null,"month from last Friday to last Thursday of the month."]
[null,null,"quarter (eg: for 1st quarter i.e jan- march) from last Friday of december to last Thursday of march"]
[null,null,"similarly half year from last Friday of december to last Thursday of june"]
[null,null,"similarly yearly from last Friday of december to last Thursday of december"]
[null,null,"pls help me with a formla for such an arrangement of dates."]
[]
[null,null,"Thanks in adv."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}