Simple question

[kohlhammond]

I want to enter the date in cell A1 and enter the next consecutive date in cell A6 and continue this format so that there are
four blank rows between dates, I don't want to manually enter in the dates, How can I get excel to recognize this pattern?

 

[sheetspread]

Put 9/1/2014 in cell A1, then this formula in A2:

=IF(MOD(ROW()-1,5)<>0,"",ROW()-1+$A$1)

and drag down

 

[skywriter]

I just tried something and it worked. I have Excel 2010. Put the first date in A1, type this formula in A6 = A1+1. Then select the blank cells below A1, but not A1 and the formula in cell A6 and drag down. It does what you want.

 

[bschwartz]

Enter the date in cell A1. Use this formula in cell A2, and fill down:

=IF(MOD(ROW()-1,5)=0,OFFSET(A2,-5,)+1,"")

 

[Taul]

Or put the first date in cell A1
The second date in cell A6
Select cells A1 to cell A10 (in other words include in the selection 4 blank cells below the last entry)
and drag down. Excel will do the rest.