{"id":288386,"date":"2021-06-30T17:24:34","date_gmt":"2021-06-30T14:24:34","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-add-or-subtract-dates-in-microsoft-excel\/"},"modified":"2021-06-30T17:24:34","modified_gmt":"2021-06-30T14:24:34","slug":"how-to-add-or-subtract-dates-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-dates-in-microsoft-excel\/","title":{"rendered":"#How to Add or Subtract Dates in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2bf07720aa7\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2bf07720aa7\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-dates-in-microsoft-excel\/#Set_Up_Your_Microsoft_Excel_Spreadsheet\" >Set Up Your Microsoft Excel Spreadsheet<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-dates-in-microsoft-excel\/#How_to_Add_or_Subtract_Days_from_Dates_in_Excel\" >How to Add or Subtract Days from Dates in Excel<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-add-or-subtract-dates-in-microsoft-excel\/#How_to_Add_or_Subtract_Months_from_Dates_in_Excel\" >How to Add or Subtract Months from Dates in Excel<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Add or Subtract Dates in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<!-- UNCACHED CONTENT --><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<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.<\/p>\n<p>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.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Set_Up_Your_Microsoft_Excel_Spreadsheet\"><\/span>Set Up Your Microsoft Excel Spreadsheet<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You\u2019ll need three columns in your sheet to accommodate the date adjustments.<\/p>\n<ol>\n<li>A column with the original dates (deadlines, due dates).<\/li>\n<li>A column to enter the number of days that you want to add or subtract.<\/li>\n<li>A column for the new dates.<\/li>\n<\/ol>\n<p>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.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Convert Text to Date Values in Microsoft Excel<\/em><\/strong><\/p>\n<p>For this example, we\u2019re using due dates, and we have the columns set up in the order described above: Due Date, Adjustment, and New Due Date.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731010\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/SetUpSheetDates-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Add columns for date adjustments in Excel\" width=\"450\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Add_or_Subtract_Days_from_Dates_in_Excel\"><\/span>How to Add or Subtract Days from Dates in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Assuming that you have the original dates to work with, enter the number of days that you want to add or subtract from the dates in that adjustment column. Enter a positive number to add to the date or a negative number to subtract from it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731011\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/AddAdjustmentDays-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter days to add or subtract\" width=\"450\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Next, go to the first cell in the column for your new dates and enter a sum formula to add the number of days to the original date. Depending on the columns and rows that you have in your sheet, the cell references might differ.<\/p>\n<p>For our sheet, we\u2019ll enter:<\/p>\n<pre>=B2+C2<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731012\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/EnterAdjustmentDaysFormula-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the adjustment sum formula\" width=\"450\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Hit Enter or Return to <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ly the formula. You can then check to make sure that the formula calculated correctly.<\/p>\n<p>To save manual work, you can use the fill handle to drag the cell containing the formula to the remaining cells in your column. Excel will automatically adjust the formulas to the corresponding cell references.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731013\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/CopyAdjustmentDaysFormula-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the fill handle to copy the formula\" width=\"485\" height=\"200\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Now that you have the formulas in your new date column, you can change the number of days in the adjustment column whenever you need to.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731014\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FinishedAdjustmentDays-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Adjusted new dates\" width=\"450\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Add_or_Subtract_Months_from_Dates_in_Excel\"><\/span>How to Add or Subtract Months from Dates in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You might have a spreadsheet where you need to add or subtract months rather than days. Maybe it\u2019s a savings, loan, or investment sheet. The setup is similar, but you\u2019ll use the EDATE function to help calculate the adjustment.<\/p>\n<p>So, be sure that you have your three columns for the original dates, number of month adjustments, and new dates, and be ready to confirm that the date columns are formatted as such.<\/p>\n<p>Enter the number of months that you want to add as positive and subtract as negative in the correct column.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731015\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/AddAdjustmentMonths-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter months to add or subtract\" width=\"500\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Go to the first cell in the column for your new dates and enter the function to add the original date to the number of months. Once more, your particular cell references might differ.<\/p>\n<p>For our sheet, we\u2019ll enter:<\/p>\n<pre>=EDATE(B2,C2)<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731016\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/EnterAdjustmentMonthsFormula-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the adjustment function\" width=\"500\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Hit Enter or Return to apply the function and confirm that it calculates correctly. Again, you can use the fill handle to drag the function to the remaining cells.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731017\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/CopyAdjustmentMonthsFormula-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Use the fill handle to copy the function\" width=\"515\" height=\"195\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And as with adding or subtracting days, you can change the number of months that you want to adjust in that column, and the function will provide you with your new dates.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-731018\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FinishedAdjustmentMonths-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Adjusted new dates\" width=\"500\" height=\"190\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p><strong>Bonus<\/strong>: If you want to add or subtract years instead of months, set up your sheet, columns, and formatting the same as described above.\u00a0Then, use the following DATE function in the new dates column with your correct cell references.<\/p>\n<pre>=DATE(YEAR(B2)+C2,MONTH(B2),DAY(B2))<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-731021 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/EnterAdjustmentYearsFunction-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter the adjustment function\" width=\"650\" height=\"182\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Another handy way to work with dates in your Excel sheets is to calculate the number of days between two dates. Check out our tutorial if you want to try it!<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/731002\/how-to-add-or-subtract-dates-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Add or Subtract Dates in Microsoft Excel&#8221; 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,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":288387,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-288386","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/288386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=288386"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/288386\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/288387"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=288386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=288386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=288386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}