How to create a sequential weekly date list, each separated by 5 r

T

Twishlist

I want to create a running sheet of dates down the page, each date is 7 days
ahead of the former. Also, each date will be separated by 5 rows before the
next date isdisplayed.
I can find date formulas that calculate number of days inbetween given
dates, but can't find a simple 'add 7 to the last date' function. It's
probably simple, but I would welcome some guidance.
 
A

AKphidelt

Put in the first date in the first cell. 5 cells down type

=1stCell + 7

then copy the blank row below the 1st cell down to the cell with the
formula. Then you should be able to paste that all the way down to how ever
many dates you want. Let me know if that works. I'm on a community computer
right now that doesn't have excel, lol.
 
S

Sebation.G

i am not clear what u mean ,but if i understand right
try:
=IF(MOD(ROW(),7)=0,($A$1+7*ROW()/7),"")
 
T

T. Valko

Here's one way.

I'm assuming you don't want anything in those 5 rows between dates.

Assume your first date is in cell A1. Manually enter that date in cell A1.
Now, select all the cells where you want the other dates to appear. I'll
assume those cells are A7, A13 and A19. Select those cells type in this
formula:

=OFFSET(A19,-6,,)+7

Now, don't just hit the ENTER key. Use the key combination of CTRL, ENTER.
That is, hold down the CTRL key then hit the ENTER key.

Format the cells as DATE

Another way to do it but use a formula in every cell.

Enter the first date in cell A1. Then enter this formula in A2 and copy down
as needed:

=IF(MOD(ROWS($1:1),6)=0,A$1+COUNT(A$1:A1)*7,"")

Format as DATE

This will put the dates in the appropriate cells and leave the other cells
blank.

Biff
 
S

Stan Brown

Tue, 15 May 2007 21:22:01 -0700 from Twishlist
I want to create a running sheet of dates down the page, each date is 7 days
ahead of the former. Also, each date will be separated by 5 rows before the
next date isdisplayed.
I can find date formulas that calculate number of days inbetween given
dates, but can't find a simple 'add 7 to the last date' function. It's
probably simple, but I would welcome some guidance.
Click to expand...

Put your first date in A1. In A6 (5 rows later) put =7+A1. Format it
as a date. Then copy cell A6 to A11, A16, A21, etc for as many weeks
as you need.
 
Top