How can I get a date to move from 1/1/05 to 1/7/05 -> 1/8/05 to 1.
 

I have a bunch of different worksheets that all need dates in 7 day intervals.

For example cell A1 has 1/2 to 1/8 and I want to drag the square at the
bottom right of the cell down to cell A2 and I want it to say 1/9 to 1/15.

Is this possible?

This should help you:

=COUNTIF(A1:C3,3)
http://www.techonthenet.com/excel/formulas/countif.htm

Ola Sandstrom

Enter the following formula in A1, and drag down:

=TEXT(DATE(2005,1,2)+(ROW(A1)-ROW($A$1)+1)*7-7,"m/d/y")&" to
"&TEXT(DATE(2005,1,8)+(ROW(A1)-ROW($A$1)+1)*7-7,"m/d/y")

Hope this helps!

In article ,
cwwolfdog wrote:

I have a bunch of different worksheets that all need dates in 7 day intervals.

For example cell A1 has 1/2 to 1/8 and I want to drag the square at the
bottom right of the cell down to cell A2 and I want it to say 1/9 to 1/15.

Is this possible?

Sorry this comment should be elsewhere
....and I'm still waiting for that Delete button...

Ola

Hi,

Use another column and use Excel's own date calculation capabilities

In A1, put 1/2
In A2, put =A1+7
drag down as you need

In B1, the following formula:
=TEXT(A1,"m/d to ") & TEXT(A1+6,"m/d")
drag down as you need

The additional column (A) enables you to carry some real dates calculations,
should you need to.

Regards,

Daniel M.

"cwwolfdog" wrote in message
...
I have a bunch of different worksheets that all need dates in 7 day intervals.

For example cell A1 has 1/2 to 1/8 and I want to drag the square at the
bottom right of the cell down to cell A2 and I want it to say 1/9 to 1/15.

Is this possible?