Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
This should help you:
=COUNTIF(A1:C3,3) http://www.techonthenet.com/excel/formulas/countif.htm Ola Sandstrom |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
Sorry this comment should be elsewhere
....and I'm still waiting for that Delete button... Ola |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date and time | New Users to Excel | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |