Now you will see the specified number of days is added or subtracted from the specified range of dates in bulk without formula. Keep these 5-digit numbers selected, and click Home > Number Format box > Short Date to convert them to dates again. Now the number is added or subtracted to the dates, and the dates display as 5-digit numbers. In the Paste Special dialog, please check Add or Subtract options as you need, and click the OK button. Select the dates you will add or subtract days, right click, and select Paste Special > Paste Special in the context menu.
Type the number of days you will add or subtract to dates in a blank cell, says 10, and then copy it. Here I will guide you to add or subtract the same number of days from multiple dates with Paste Special feature in Excel.ġ.
Enjoy a full-featured 30-day FREE trial with no credit card required! Get It Now Add or subtract days to multiple dates without formulaĬomparing to formulas, some Excel users prefer to add or subtract days directly without formulas. Kutools for Excel - Supercharge Excel with over 300 essential tools.
