changing dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a chart with dates (by month/day/year) that I have to continually
update each month. Is there a way to change the dates by page instead of row
by row?
Excel 2003
 
It's not clear what you're updating, but here's one idea.

Enter the starting date in one cell, and use formulas in the cells
below, to increase the date by one day.

For example, with the starting date in cell A2, in cell A3 enter:

=A2+1

Copy down as far as required.

At the beginning of the next month, change the starting date.
 
Back
Top