{"id":1459,"date":"2018-12-11T08:31:42","date_gmt":"2018-12-11T14:31:42","guid":{"rendered":"http:\/\/xlfxs.com\/?p=1459"},"modified":"2018-12-11T08:31:42","modified_gmt":"2018-12-11T14:31:42","slug":"looplist-repeating-months-using-formulas","status":"publish","type":"post","link":"https:\/\/xlfxs.com\/?p=1459","title":{"rendered":"Looplist &#8211; Repeating months using formulas"},"content":{"rendered":"<p>Using formulas to repeat list, I call it LoopList<\/p>\n<p>Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps into next year and loop through its months again, and so on<\/p>\n<p><!--more--><\/p>\n<div id='gallery-1' class='gallery galleryid-1459 gallery-columns-3 gallery-size-thumbnail'><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/?attachment_id=1464'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/LoopList1-2-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/?attachment_id=1462'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/LoopList-2-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/?attachment_id=1461'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/LoopList4-2-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure><figure class='gallery-item'>\n\t\t\t<div class='gallery-icon landscape'>\n\t\t\t\t<a href='https:\/\/xlfxs.com\/?attachment_id=1460'><img loading=\"lazy\" decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/LoopList3-2-150x150.jpg\" class=\"attachment-thumbnail size-thumbnail\" alt=\"\" \/><\/a>\n\t\t\t<\/div><\/figure>\n\t\t<\/div>\n\n<p>&nbsp;<\/p>\n<div class=\"row\">\n<div class=\"col-md-6\"><a class=\"btn btn-info btn-lg\" href=\"http:\/\/xlfxs.com\/wp-content\/uploads\/2018\/12\/LoopList.xlsx\"><i class=\"fa fa-download\"><\/i> Download<\/a><\/div>\n<div class=\"col-md-6\"><a class=\"btn btn-info btn-lg\" href=\"https:\/\/1drv.ms\/x\/s!An4iomsT7EVO2M5vQrN3H3ZxmXKtlA\"><i class=\"fa fa-cloud\"><\/i> Online Excel version<\/a><\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop through all months, then jumps into next year and loop through its months again, and so on<\/p>\n","protected":false},"author":1,"featured_media":1464,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,23,3,37,42,47,51,65],"tags":[],"class_list":["post-1459","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-basic-math","category-date-and-time","category-formulas","category-match","category-month","category-offset","category-row","category-year"],"_links":{"self":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1459","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1459"}],"version-history":[{"count":0,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/posts\/1459\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=\/wp\/v2\/media\/1464"}],"wp:attachment":[{"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xlfxs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}