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

[Guest]

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?

 

[Guest]

This should help you:

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

Ola Sandstrom

 

[Domenic]

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!

 

[Guest]

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

Ola

 

[Daniel.M]

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.