Massive Date Replication (Probably Easy)

  • Thread starter Thread starter tgilbreath
  • Start date Start date
T

tgilbreath

Hi guys, probably basic question but, this is what I need.

I have 50 rows of a date in Column A, for example, 1/1.

I need 50 rows of each day in the year, so 50 rows of 1/2, 50 rows
below that of 1/3. What formula would I use to pull this off?

Thanks!

T
 
One way:

=DATE(2005,1,1+INT((ROW()-1)/50))

Copy down.

Alternatively:

A1: 1/1
A2: =$A$1+INT((ROW()-1)/50)
 
First, format the cells with Date Format (Format?cells/Date/"3/14").
Type 1/1 in the first cell
Grab the handle on the forst cell and drag right
Select colunms of dates with fifty rows
"Control-D"
Done
 
Back
Top