{"id":13079,"date":"2021-07-25T01:48:59","date_gmt":"2021-07-25T01:48:59","guid":{"rendered":"https:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/"},"modified":"2021-07-25T01:48:59","modified_gmt":"2021-07-25T01:48:59","slug":"how-to-add-or-subtract-dates-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/thedailyherald.co.uk\/lifestyle\/how-to-add-or-subtract-dates-in-microsoft-excel\/","title":{"rendered":"How to Add or Subtract Dates in Microsoft Excel"},"content":{"rendered":"<p>Adjusting dates on a spreadsheet can be cumbersome. Rather than digging out your calendar to count days or months, you can adjust dates right in Microsoft Excel with simple addition or subtraction. Whether it\u2019s a project schedule with deadlines, a budget with due dates for bills, or an inventory sheet with shipping dates, adjusting those dates doesn\u2019t have to be a pain. In a few simple steps, you can enter the addition or subtraction and calculate your new dates automatically. Set Up Your Microsoft Excel Spreadsheet You\u2019ll need three columns in your sheet to accommodate the date adjustments. A column with the original dates (deadlines, due dates). A column to enter the number of days that you want to add or subtract. A column for the new dates. Depending on which data you already have in your sheet, the first step is to make sure that you have these columns. Also, make sure that the date columns are formatted for dates in whichever style you prefer. RELATED: How to Convert Text to Date Values in Micros&#8230; Click below to read the full story from How To Geek<br \/><a href=\"https:\/\/www.howtogeek.com\/731002\/how-to-add-or-subtract-dates-in-microsoft-excel\/\" class=\"button purchase\" rel=\"nofollow noopener\" target=\"_blank\">Read More<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Adjusting dates on a spreadsheet can be cumbersome. Rather than digging out your calendar to count days or months, you can adjust dates right in Microsoft Excel with simple addition or subtraction. Whether it\u2019s a project schedule with deadlines, a budget with due dates for bills, or an inventory sheet with shipping dates, adjusting those&hellip;<\/p>\n","protected":false},"author":1063,"featured_media":13080,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[36],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Add or Subtract Dates in Microsoft Excel - The Daily Herald<\/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:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Add or Subtract Dates in Microsoft Excel - The Daily Herald\" \/>\n<meta property=\"og:description\" content=\"Adjusting dates on a spreadsheet can be cumbersome. Rather than digging out your calendar to count days or months, you can adjust dates right in Microsoft Excel with simple addition or subtraction. Whether it\u2019s a project schedule with deadlines, a budget with due dates for bills, or an inventory sheet with shipping dates, adjusting those&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"The Daily Herald\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-25T01:48:59+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"Sandy Writtenhouse\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/thedailyherald.co.uk\/#website\",\"url\":\"https:\/\/thedailyherald.co.uk\/\",\"name\":\"The Daily Herald\",\"description\":\"Your Super Aggregated News, Blog &amp; Magazine\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/thedailyherald.co.uk\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/thedailyherald.co.uk\/wp-content\/uploads\/2021\/07\/13079-how-to-add-or-subtract-dates-in-microsoft-excel.png\",\"width\":2392,\"height\":1342,\"caption\":\"How to Add or Subtract Dates in Microsoft Excel\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/#webpage\",\"url\":\"https:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/\",\"name\":\"How to Add or Subtract Dates in Microsoft Excel - The Daily Herald\",\"isPartOf\":{\"@id\":\"https:\/\/thedailyherald.co.uk\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/#primaryimage\"},\"datePublished\":\"2021-07-25T01:48:59+00:00\",\"dateModified\":\"2021-07-25T01:48:59+00:00\",\"author\":{\"@id\":\"https:\/\/thedailyherald.co.uk\/#\/schema\/person\/a8468cee44c0e3656f683a17d1791137\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/thedailyherald.co.uk\/uncategorized\/how-to-add-or-subtract-dates-in-microsoft-excel\/\"]}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/thedailyherald.co.uk\/#\/schema\/person\/a8468cee44c0e3656f683a17d1791137\",\"name\":\"Sandy Writtenhouse\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/thedailyherald.co.uk\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/90b5590081e9c34adf775dcb561b979f?s=96&d=mm&r=g\",\"caption\":\"Sandy Writtenhouse\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","amp_validity":null,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/posts\/13079"}],"collection":[{"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/users\/1063"}],"replies":[{"embeddable":true,"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/comments?post=13079"}],"version-history":[{"count":0,"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/posts\/13079\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/media\/13080"}],"wp:attachment":[{"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/media?parent=13079"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/categories?post=13079"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thedailyherald.co.uk\/wp-json\/wp\/v2\/tags?post=13079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}