{"id":18488,"date":"2016-10-23T00:34:38","date_gmt":"2016-10-23T00:34:38","guid":{"rendered":"http:\/\/www.oracletutoring.ca\/blog\/?p=18488"},"modified":"2016-10-23T00:34:38","modified_gmt":"2016-10-23T00:34:38","slug":"spreadsheets-calculating-fraction-of-a-year-yearfrac-function","status":"publish","type":"post","link":"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-calculating-fraction-of-a-year-yearfrac-function\/","title":{"rendered":"Spreadsheets:  Calculating fraction of a year:  yearfrac() function"},"content":{"rendered":"<h1>The tutor shows an example of how to use the yearfrac() function in Excel or LibreOffice Calc.<\/h1>\n<p><strong>Example:  Find the fraction of a year between January 10, 2016, and June 2, 2016.<\/strong><\/p>\n<p>Solution:<\/p>\n<ol>\n<li>In Excel or LibreOffice Calc, select a cell.<\/li>\n<li>Type the following:<br \/>\n<span style=\"color:#992255\">=yearfrac(date(2016,01,10),date(2016,06,02),1)<\/span><\/li>\n<li>Press Enter.<\/li>\n<\/ol>\n<p>Hopefully you receive the answer 0.39344<\/p>\n<p>The third parameter (which is set at 1 in the example above) can be set 0,1,2,3, or 4:  the options include a 30-day month, a 360-day year, or the actual length of a given month and year, etc.  If you leave it blank or zero, it uses the American 30-day month, 360-day year system.  &#8220;1&#8221; means actual values of days.<\/p>\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 shows an example of how to use the yearfrac() function in Excel or LibreOffice Calc. Example: Find the fraction of a year between January 10, 2016, and June 2, 2016. Solution: In Excel or LibreOffice Calc, select a &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"more-link\" href=\"https:\/\/www.oracletutoring.ca\/blog\/spreadsheets-calculating-fraction-of-a-year-yearfrac-function\/\"> <span class=\"screen-reader-text\">Spreadsheets:  Calculating fraction of a year:  yearfrac() function<\/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],"tags":[1982],"class_list":["post-18488","post","type-post","status-publish","format-standard","hentry","category-business","category-excel","category-libreoffice-calc","category-spreadsheets","tag-calculating-fraction-of-a-year"],"_links":{"self":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18488","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=18488"}],"version-history":[{"count":6,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18488\/revisions"}],"predecessor-version":[{"id":18494,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/posts\/18488\/revisions\/18494"}],"wp:attachment":[{"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/media?parent=18488"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/categories?post=18488"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.oracletutoring.ca\/blog\/wp-json\/wp\/v2\/tags?post=18488"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}