Is it possible to change the first date on the attached spreadsheet and have the rest prefill a week later.
Last edited by fernj; 03-18-2010 at 01:35 PM.
Dates in excel are integer values displayed in a date format. If you want one cell seven days after another, just add seven to it. In your example, make cell A5
=A3+7
Is that what you meant?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
awesome. yes. I am getting a hang of these excel formulas. still got a long ways to learn.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks