dates

G

Guido

I would like to put a date in say, a1 and than have a formula advance that
date by 7 days in the second row down. And to continue this for some period
of time.
Is this feasible?
A1 June 6,2005
A3 June 13,2005
A5 June 20,2005
ect.

Thanks
 
R

Ron de Bruin

Hi Guido

No need for a formula

In A1 the first date
in A3 the second date (7 days later)

Now select
A1:A4

Copy down this four cells now
 
R

Ron Rosenfeld

I would like to put a date in say, a1 and than have a formula advance that
date by 7 days in the second row down. And to continue this for some period
of time.
Is this feasible?
A1 June 6,2005
A3 June 13,2005
A5 June 20,2005
ect.

Thanks
Click to expand...

A1: June 6, 2005
A3: =A1+7
A5: =A3+7
etc.

An easier way:

=$A$1+INT(ROW()/2)*7

entered into A3, A5, etc.

Problem is how to easily select just the odd cells.

Here's one way.

A1: your starting date

With no date format in A3:An, enter

A3: 1
A4: 2

Select A3:A4 and copy/drag down to An. You may need to hold down <ctrl> while
you do this because the goal is a column of alternating 1's and 2's.

With the range still selected, Data/Filter/Auto filter; click on the down arrow
and select the 1

With the cells still selected; Edit/Goto/Special Visible Cells Only <OK>

Edit/Replace and Replace the 1 with the formula =$A$1+INT(ROW()/2)*7

Then select to filter and show only the '2'.

Select the range that includes the 2's (do NOT select A3 where the down arrow
is)

Edit/Goto/Special Visible Cells only

Delete

Data/Autofilter (selecting it will turn off the auto filter)

And you're done.


--ron
 
B

bj

enter your date in A1
in A2 enter =A1+7
copy down as far as you want.
Format Column A as a date.
 
K

Kevin M

Guido, you can simply autofill the dates as you wish. I just tested it in
Excel XP. Enter the first date, blank, second date, blank, then select all
four and autofill as far as you need to.

HTH,
Kevin M
MOS Excel Specialist
 
R

Ron Rosenfeld

Forget all I wrote.

Much simpler.

A1: Initial Date.
A3: =$A$1+7*INT(ROW()/2)
A4: -- nothing here --
Now select A3:A4

Put your cursor over the lower right corner where it will change into a
cross-hair, then drag down as far as needed.


--ron
 
Top