Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2004

Tip: Looking for answers? Try searching our database.

changing dates

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lkidd - 04 Oct 2004 20:17 GMT
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
Debra Dalgleish - 05 Oct 2004 00:26 GMT
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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.