How to Add or Subtract Dates in Microsoft Excel

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’s a project schedule with deadlines, a budget with due dates for bills, or an inventory sheet with shipping dates, adjusting those dates doesn’t 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’ll 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… Click below to read the full story from How To Geek
Read More