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.
> 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

Signature
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html