{"id":61112,"date":"2022-08-05T23:01:19","date_gmt":"2022-08-05T15:01:19","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=61112"},"modified":"2022-08-05T18:34:59","modified_gmt":"2022-08-05T10:34:59","slug":"google-sheets-get-due-dates","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/","title":{"rendered":"How to Calculate Due Dates with Google Sheets"},"content":{"rendered":"

Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you\u2019d be able to figure it out quickly without much calculation.<\/p>\n

Likewise, when someone asks you about a date six months after the 12th of August 2022? That may require a bit of work, and you can answer it with a quick Google search.<\/p>\n

But what if there are many different events that you have to calculate the due date for (like in the screenshot below), then googling one by one can be troublesome.<\/p>\n

\"dates<\/figure>\n

And that is where Google Sheets can help you out. By applying simple formulas, you can calculate multiple due dates within seconds<\/strong>. In the following, you can read about how to do that.<\/p>\n

What are we going to achieve here?<\/h2>\n

This tutorial will enable you to use Google Sheets<\/strong> to input as many start dates as you want<\/strong> along with the duration in which they\u2019re due<\/strong>.<\/p>\n

It will then automatically calculate the due date<\/strong> for you.<\/p>\n

Let\u2019s get started<\/h2>\n

Now, open a blank new Google Sheet and dive into it.<\/p>\n

    \n
  1. Insert \u201cStart date<\/strong>\u201c, \u201cDue in (days)<\/strong>\u201c, and \u201cEnd date<\/strong>\u201d in 3 separate Columns.<\/li>\n
    \"insert<\/figure>\n
  2. Click A<\/strong> to select the entire \u201cStart date\u201d Column, hold down Control<\/span> key (Windows), or Command<\/span> key (Mac), left click once<\/strong> on \u201cStart date\u201d cell to deselect it.<\/li>\n
    \"select<\/figure>\n
  3. Go to Format<\/strong> > Number<\/strong> and select Date<\/strong>. This will ensure all cells (except A1) are formatted as mm\/dd\/yyyy<\/code>. If you want to use a different format, go to Format<\/strong> > Number<\/strong> and select Custom date and time<\/strong>.<\/li>\n
    \"format<\/figure>\n
  4. Repeat step 2 and step 3<\/strong> for the \u201cEnd date\u2019 Column.<\/li>\n
  5. Click B<\/strong> to select the entire \u201cDue in\u201d Column, hold down Control<\/span> key (Windows), or Command<\/span> key (Mac), left click once<\/strong> on \u201cDue in\u201d cell to deselect it, then go to Format<\/strong> > Number<\/strong> > Number<\/strong>.<\/li>\n
  6. Now, let\u2019s give it the formula so it calculates the end date for us. Go to the first Column under End date (C2), and enter this formula: =IF(B2<>\"\",A2+B2,\"\")<\/code>, and hit Enter<\/span>.<\/li>\n
  7. Drag this cell down<\/strong> as fast as you want it to go, so the formula applies to other cells as well.<\/li>\n
    \"drag<\/figure>\n<\/ol>\n

    Testing the Sheet<\/h2>\n

    So basically, what the formula does is that when you enter a start date and how long it\u2019s due, Column C displays its end date accurately.<\/p>\n

    To test the formula we added in Google Sheets with the aforementioned steps, we will enter a start date, say 8\/13\/2022, and add that it dues in 20 days. The result should show that the end date will be 9\/2\/2022.<\/p>\n

    \"test<\/figure>\n

    Making it more beautiful<\/h2>\n

    If you\u2019re going to use this feature of Google Sheets more often, then we might as well make it look a little more presentable.<\/p>\n

    \"beautifying<\/figure>\n

    Here are a few things I did to make it neater.<\/p>\n

      \n
    1. Replace default font with Cambria, size 11.<\/li>\n
    2. For Row 1, fill color, bold text, and centralized title.<\/li>\n
    3. Freeze Row 1, so it does not move when scrolling. (View<\/strong> > Freeze<\/strong> > 1 row<\/strong>).<\/li>\n
    4. Alternating row colors. (Format<\/strong> > Alternating colors<\/strong>).<\/li>\n<\/ol>\n

      Click here<\/a> to get a copy of the final sample.<\/p>","protected":false},"excerpt":{"rendered":"

      Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you\u2019d be able to figure it out quickly without much calculation. Likewise, when someone asks you about a date six months after the 12th of August 2022? That…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[3398],"tags":[4554],"topic":[],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"\nHow to Calculate Due Dates with Google Sheets - Hongkiat<\/title>\n<meta name=\"description\" content=\"Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you'd be able to figure it out\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Calculate Due Dates with Google Sheets\" \/>\n<meta property=\"og:description\" content=\"Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you'd be able to figure it out\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-05T15:01:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-get-due-dates\/dates-to-calculate.jpg\" \/>\n<meta name=\"author\" content=\"Hongkiat Lim\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Hongkiat Lim\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/\"},\"author\":{\"name\":\"Hongkiat Lim\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/e3613a3bf757e4f67770f0b7a339edd0\"},\"headline\":\"How to Calculate Due Dates with Google Sheets\",\"datePublished\":\"2022-08-05T15:01:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/\"},\"wordCount\":522,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-get-due-dates\\\/dates-to-calculate.jpg\",\"keywords\":[\"Google Sheets\"],\"articleSection\":[\"Internet\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/\",\"name\":\"How to Calculate Due Dates with Google Sheets - Hongkiat\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-get-due-dates\\\/dates-to-calculate.jpg\",\"datePublished\":\"2022-08-05T15:01:19+00:00\",\"description\":\"Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you'd be able to figure it out\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-get-due-dates\\\/dates-to-calculate.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/google-sheets-get-due-dates\\\/dates-to-calculate.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/google-sheets-get-due-dates\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Calculate Due Dates with Google Sheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/e3613a3bf757e4f67770f0b7a339edd0\",\"name\":\"Hongkiat Lim\",\"description\":\"Founder and Editor in Chief of Hongkiat.com. Hongkiat is also a designer, developer, entrepreneur, and an active investor in the US stock market.\",\"sameAs\":[\"http:\\\/\\\/www.hongkiat.com\\\/blog\"],\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/hongkiat\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Calculate Due Dates with Google Sheets - Hongkiat","description":"Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you'd be able to figure it out","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:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/","og_locale":"en_US","og_type":"article","og_title":"How to Calculate Due Dates with Google Sheets","og_description":"Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you'd be able to figure it out","og_url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2022-08-05T15:01:19+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-get-due-dates\/dates-to-calculate.jpg","type":"","width":"","height":""}],"author":"Hongkiat Lim","twitter_card":"summary_large_image","twitter_creator":"@hongkiat","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Hongkiat Lim"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/"},"author":{"name":"Hongkiat Lim","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/e3613a3bf757e4f67770f0b7a339edd0"},"headline":"How to Calculate Due Dates with Google Sheets","datePublished":"2022-08-05T15:01:19+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/"},"wordCount":522,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-get-due-dates\/dates-to-calculate.jpg","keywords":["Google Sheets"],"articleSection":["Internet"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/","url":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/","name":"How to Calculate Due Dates with Google Sheets - Hongkiat","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-get-due-dates\/dates-to-calculate.jpg","datePublished":"2022-08-05T15:01:19+00:00","description":"Say the date today is the 12th of August 2022. If I were to ask you what the date is tomorrow and the date the day after, you'd be able to figure it out","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-get-due-dates\/dates-to-calculate.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/google-sheets-get-due-dates\/dates-to-calculate.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/google-sheets-get-due-dates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Calculate Due Dates with Google Sheets"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/e3613a3bf757e4f67770f0b7a339edd0","name":"Hongkiat Lim","description":"Founder and Editor in Chief of Hongkiat.com. Hongkiat is also a designer, developer, entrepreneur, and an active investor in the US stock market.","sameAs":["http:\/\/www.hongkiat.com\/blog"],"url":"https:\/\/www.hongkiat.com\/blog\/author\/hongkiat\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-fTG","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/61112","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=61112"}],"version-history":[{"count":2,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/61112\/revisions"}],"predecessor-version":[{"id":61114,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/61112\/revisions\/61114"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=61112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=61112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=61112"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=61112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}