@VickiE2232
I will assume that by "all the daily data" you mean the date values only.
It likely would be difficult for either a formula or VBA code to determine which numeric values are dates _and_ which dates need to be modified (e.g., dates in the past should probably not be modified after a certain interval, but the current date might or might not qualify). An easy technique, without using either formulas or VBA…
If your dates are literals (i.e., they are not the result of formulas), and if you can readily select all of the appropriate dates (e.g., if they are all within one column, and preferably in contiguous cells), you can do this:
- Put the number 1 (representing one day) into some unused cell. It does not have to be located on the same sheet. The formatting does not matter, so long as this is not Text.
- Copy that cell (e.g., press Ctrl+C).
- Select the dates that you want to modify.
- Right-click one of the selected cells, and then click "Paste Special…" in the popup menu. The Paste Special dialog appears.
- In the Paste section, click the Values radio button. In the Operation section, click the Add radio button. Then click OK.
- You can clear the cell containing the 1.
And of course, if there are multiple blocks of cells containing dates that you want to increment, you can repeat steps 3 through 5 before continuing with step 6.
