{"id":18474,"date":"2016-10-22T01:38:30","date_gmt":"2016-10-22T01:38:30","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18474"},"modified":"2016-10-25T19:46:37","modified_gmt":"2016-10-25T19:46:37","slug":"spreadsheets-which-day-in-the-year-is-this-calculated-with-excel-or-libreoffice-calc","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-which-day-in-the-year-is-this-calculated-with-excel-or-libreoffice-calc\/","title":{"rendered":"Spreadsheets:  which day in the year is this?  -Calculated with Excel or LibreOffice Calc"},"content":{"rendered":"<h1>The tutor tells how to find the number of a day in the year with Excel or LibreOffice Calc.<\/h1>\n<p>Today, October 21, 2016, is the 295th day of 2016.  How do I know?  Here are two ways:<\/p>\n<ol>\n<li>\nCounting the days in the remaining months, then subtracting from 366. (2016, being divisible by 4, is a leap year.)  366 &#8211; 31 (Dec) -30 (Nov) -10 (remaining Oct) =366 &#8211; 71 = 295.\n<\/li>\n<li>\nTaking today&#8217;s date, then subtracting Dec 31, 2015 from it, to get the days so far this year.  This is done in Exel, or LibreOffice Calc, by selecting a cell, then entering the following:<\/p>\n<p><span style=\"color:#990055\">=today() &#8211; date(2015,12,31)<\/span>\n<\/li>\n<\/ol>\n<p>HTH:)<\/p>\n<p>Jack of <a href=\"https:\/\/www.oracletutoring.ca\">Oracle Tutoring by Jack and Diane,<\/a> Campbell River, BC.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The tutor tells how to find the number of a day in the year with Excel or LibreOffice Calc. Today, October 21, 2016, is the 295th day of 2016. How do I know? Here are two ways: Counting the days &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-which-day-in-the-year-is-this-calculated-with-excel-or-libreoffice-calc\/\"> <span class=\"screen-reader-text\">Spreadsheets:  which day in the year is this?  -Calculated with Excel or LibreOffice Calc<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[371,1583,1951,1065,458],"tags":[1978,1981,1980,1979],"class_list":["post-18474","post","type-post","status-publish","format-standard","hentry","category-business","category-excel","category-libreoffice-calc","category-spreadsheets","category-technology","tag-day-in-the-year","tag-position-of-today-in-the-year","tag-where-a-day-sits-in-the-year","tag-which-day-in-the-year-is-today"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18474","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/comments?post=18474"}],"version-history":[{"count":14,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18474\/revisions"}],"predecessor-version":[{"id":18519,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18474\/revisions\/18519"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18474"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18474"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18474"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}