alternate rows with date

[oldLearner57]

hi community

how can i fill up alternate rows with a series of date that runs consecutively

example:

A B C D

1 01-May

2

3 02-May

4

5 03-May

can this sort of series fill possible?


thanks community

 

[Don Guillett]

One way

Sub datesinaltrows()
mc = "d"
sd = InputBox("Enter start date, ie 7/4")
nd = InputBox("Enter number of days")
Cells(1, mc) = sd
For i = 2 To nd
Cells(i * 2 - 1, mc) = Cells(1, mc) + i - 1
Next i
End Sub

 

[John Bundy]

The fastest way is to insert a column, then put in the following formula and
copy it down.
=IF(B2="",B1,B2)

We are just say that if the cell is blank, use the value in the cell above
it, if not then leave it alone.

 

[FSt1]

hi
another way.
enter date 5/1/08in A1
enter next date 5/2/08 in A3
high like range A1:A4
place curson over lower right corner of selected area until curser turn into
a small black cross. click and hold. drag down as far as you want.

regards
FSt1

 

[oldLearner57]

10s!..it was wonderful, so easy yet so difficult if not enlighted

10s community

 

[Jarek Kujawa]

that seems not to work on my Excel 2003
;-(

 

[oldLearner57]

10s! John Bundy, was interesting to know abt the formula
however
along the alternate row that was supposed to be blank, it shows some data
like 0-Jan

example:

A B C

1 01-May

2 0-Jan

3 02-May

4 0-Jan

able to use the formula, =if(b2="",b1,b2)
how can i remove the 0-Jan to have the alternate row with a Blank?

thanks for your great help!!

thanks community as well

 

[oldLearner57]

hi Don Guillet, much appreciated for your assistance

thanks You

thanks community as well

 

[FSt1]

works in mine. apparently in oldLearner57 too.

regards
FSt1

 

[Jarek Kujawa]

must have missed sth.

sorry

 

[Gord Dibben]

Jarek

Note to select A1:A4 so's you have a blank cell below both dates when you start
to drag.


Gord