{"id":65803,"date":"2019-03-21T09:36:19","date_gmt":"2019-03-21T09:36:19","guid":{"rendered":"https:\/\/mosaicmkt.com\/?p=65803"},"modified":"2019-03-21T09:36:19","modified_gmt":"2019-03-21T09:36:19","slug":"calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets","status":"publish","type":"post","link":"http:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/","title":{"rendered":"Calculate Percentage of Month for Dashboard Reporting in Google Sheets"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">We often put together dashboards that show performance for the current month against goals. \u00a0This requires that we determine the percentage of the month already passed in order to build the forecast for the remainder of the month. \u00a0Here is a formula for Google Sheets that allows you to determine the percentage of the month already passed as of yesterday (i.e. the number of days of the month already passed\/the total days of the month). <\/span><\/p>\n<p><span style=\"font-weight: 400;\">=(day(now())-<\/span><span style=\"font-weight: 400;\">1<\/span><span style=\"font-weight: 400;\">)\/DAY(EOMONTH(now(),<\/span><span style=\"font-weight: 400;\">0<\/span><span style=\"font-weight: 400;\">))<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Now you can divide your actuals by this percentage to determine the forecast for the month. \u00a0\u00a0\u00a0<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>We often put together dashboards that show performance for the current month against goals. \u00a0This requires that we determine the percentage of the month already passed in order to build the forecast for the remainder of the month. \u00a0Here is a formula for Google Sheets that allows you to determine the percentage of the month [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","content-type":"","_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"episode_type":"","audio_file":"","cover_image":"","cover_image_id":"","duration":"","filesize":"","date_recorded":"","explicit":"","block":"","filesize_raw":"","footnotes":""},"categories":[1],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculate Percentage of Month for Dashboard Reporting in Google Sheets - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculate Percentage of Month for Dashboard Reporting in Google Sheets - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\" \/>\n<meta property=\"og:description\" content=\"We often put together dashboards that show performance for the current month against goals. \u00a0This requires that we determine the percentage of the month already passed in order to build the forecast for the remainder of the month. \u00a0Here is a formula for Google Sheets that allows you to determine the percentage of the month [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/\" \/>\n<meta property=\"og:site_name\" content=\"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-21T09:36:19+00:00\" \/>\n<meta name=\"author\" content=\"mosaicmktadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mosaicmktadmin\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/\",\"url\":\"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/\",\"name\":\"Calculate Percentage of Month for Dashboard Reporting in Google Sheets - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\",\"isPartOf\":{\"@id\":\"https:\/\/stage.mosaicmkt.com\/#website\"},\"datePublished\":\"2019-03-21T09:36:19+00:00\",\"dateModified\":\"2019-03-21T09:36:19+00:00\",\"author\":{\"@id\":\"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613\"},\"breadcrumb\":{\"@id\":\"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stage.mosaicmkt.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calculate Percentage of Month for Dashboard Reporting in Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/#website\",\"url\":\"https:\/\/stage.mosaicmkt.com\/\",\"name\":\"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups\",\"description\":\"Leading Marketing Agency for High Growth Businesses Serving Private Equity, VCs and Start-Ups\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stage.mosaicmkt.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613\",\"name\":\"mosaicmktadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g\",\"caption\":\"mosaicmktadmin\"},\"url\":\"http:\/\/stage.mosaicmkt.com\/author\/mosaicmktadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculate Percentage of Month for Dashboard Reporting in Google Sheets - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/","og_locale":"en_US","og_type":"article","og_title":"Calculate Percentage of Month for Dashboard Reporting in Google Sheets - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","og_description":"We often put together dashboards that show performance for the current month against goals. \u00a0This requires that we determine the percentage of the month already passed in order to build the forecast for the remainder of the month. \u00a0Here is a formula for Google Sheets that allows you to determine the percentage of the month [&hellip;]","og_url":"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/","og_site_name":"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","article_published_time":"2019-03-21T09:36:19+00:00","author":"mosaicmktadmin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"mosaicmktadmin"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/","url":"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/","name":"Calculate Percentage of Month for Dashboard Reporting in Google Sheets - Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","isPartOf":{"@id":"https:\/\/stage.mosaicmkt.com\/#website"},"datePublished":"2019-03-21T09:36:19+00:00","dateModified":"2019-03-21T09:36:19+00:00","author":{"@id":"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613"},"breadcrumb":{"@id":"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stage.mosaicmkt.com\/calculate-percentage-of-month-for-dashboard-reporting-in-google-sheets\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stage.mosaicmkt.com\/"},{"@type":"ListItem","position":2,"name":"Calculate Percentage of Month for Dashboard Reporting in Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/stage.mosaicmkt.com\/#website","url":"https:\/\/stage.mosaicmkt.com\/","name":"Mosaic Growth Solutions - B2B SaaS Marketing Agency for High-Growth Businesses Serving Private Equity, VCs and Start-Ups","description":"Leading Marketing Agency for High Growth Businesses Serving Private Equity, VCs and Start-Ups","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stage.mosaicmkt.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/46c7fc8058a9ce83ee50b3457a30c613","name":"mosaicmktadmin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/stage.mosaicmkt.com\/#\/schema\/person\/image\/","url":"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g","contentUrl":"http:\/\/0.gravatar.com\/avatar\/f8be81a2cb99babb5eb086cbc4ce50b4?s=96&d=mm&r=g","caption":"mosaicmktadmin"},"url":"http:\/\/stage.mosaicmkt.com\/author\/mosaicmktadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts\/65803"}],"collection":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/comments?post=65803"}],"version-history":[{"count":1,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts\/65803\/revisions"}],"predecessor-version":[{"id":65804,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/posts\/65803\/revisions\/65804"}],"wp:attachment":[{"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/media?parent=65803"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/categories?post=65803"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/stage.mosaicmkt.com\/wp-json\/wp\/v2\/tags?post=65803"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}