If you need to add a different number of days to each date, you can type out the number of days you need to add to each row in a separate column (as shown below). You will get the result of adding 15 days to the date in cell A2. This means, your cell H2 should have the formula =A2+15. So, if you want to add 15 days, type ‘+15’ in the same cell.
Next, type ‘+’ followed by the number of days you want to add.Type ‘=’ and select the first cell of the column containing the dates you want to add days to (cell A2).
Select the first cell of the column you want to store the result in (in our example, cell H2).Let us assume you want to add a fixed number of days (say 15 days) to every date in column A and store the result of the addition in Column H. For this tutorial, we will be using the dataset shown below:
