Note: It’s important to select the Value option in Step 6 as this makes sure that the format of the dates remains unchanged. In case you want to subtract from a date, select the Subtract option in Step 7. The above steps would add 10 to all the dates in the selection. This will open the Paste Special dialog box

Copy this cell (the one in which we enter the value 10).In an empty cell, enter 10 (the number that we want to add to the dates).This is a perfect example where I would need to add a fixed number of days to the due date so that I can get the new date for each task.Įxcel has an in-built Paste Special functionality that allows you to quickly add or subtract a fixed number from a range of selected cells.īelow are the steps to add 10 days to the existing dates in our data set: The writer came back to me and asked me to shift all these due dates by 10 days, as she had some urgent stuff to take care of and needed 10 days off. I sent her a list of articles with the due dates to the writer (as shown below). Recently, I was working with one of the content writers on one of my projects. Adding Varying Number of Days to a DateĪdd or Subtract Days to Dates in Excel Using Paste Special.Add or Subtract Days to Dates Using Formulas.Add or Subtract Days to Dates in Excel Using Paste Special.