Why do you need two columns? You can format the cell to only display the day
and leave the dates +7 in the cell.



--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Squirel Eater" wrote in message
...
Thanks! I have solved the problem. Your info below gave me the clue. I
will use a row with the dates as you did. I will then turn that row into
a
day() and that will do what I wanted. I assume I will be able to hide the
unwanted row.

Thanks again.

"CLR" wrote:

Using XL2k, when I put 3/6/2005 in A1 and =A1+7 in B1 and drag B1 out to
I1,
I get:

B1= 3/13/2005
C1= 3/20/2005
D1= 3/27/2005
E1= 4/3/2005
F1= 4/10/2005
G1 = 4/17/2005
H1= 4/24/2005
I1= 5/1/2005

"No 4/31/2005 in sight"
Is this not what you asked for?
"WHERE" are you getting the 4/31/2005?, and by what means?

Vaya con Dios,
Chuck, CABGx3





"Squirel Eater" wrote in message
...
Yes I agree, but, it will return a date of April 31, 2005 even though
this
date is not true. I am looking for a surefire solution. By the way

Last day of the this month:
=DATE(YEAR("04/01/2005"),MONTH("04/01/2005")+1,1)-1

returns 4/30/2005

Thanks for the input

"CLR" wrote:

If you put a date in A1, then in B1 put

=A1+7, and copy it over to as many columns to the right as you
wish.......each will increment 7 days.

Vaya con Dios,
Chuck, CABGx3



"Squirel Eater" <Squirel wrote in
message
...
How can I set a date in subsequent columns that are 7 days apart?
I
have
tried
=DAY(IF(B3="","",B3+7)) but if given a date March 6, 2005 it will
show 31
days in April. Any suggestions?