sequential date

[Garry]

Is it possible to have in sequence a date value

I require four dates the same before sequencing the next date, so

01/01/11
01/01/11
01/01/11
01/01/11
02/01/11
02/01/11
02/01/11
02/01/11
03/01/11
03/01/11
03/01/11
03/01/11

etc etc

Cheers

 

[DanielCo]

In A1 : initial date
In A2 :
=IF(COUNTIF($A$1:A1,A1)<4,A1,A1+1)
copy down as needed.
Daniel

 

[Don Guillett]

In A1 : initial date
In A2 :
=IF(COUNTIF($A$1:A1,A1)<4,A1,A1+1)
copy down as needed.
Daniel

Another idea withOUT formulas to start with today and increase as
desired
Sub doDates()
fn = Date
For i = 1 To 120 Step 4
Cells(i, 1).Resize(4) = fn
fn = fn + 1
Next i
End Sub

 

[joeu2004]

I require four dates the same before sequencing
the next date, so 01/01/11
01/01/11
01/01/11
01/01/11
02/01/11
02/01/11
02/01/11
02/01/11

[....]

Put the initial date into A1, put =A1 into A2 and copy down through A4.
Then put =A1+1 into A5 and copy down as needed

 

[Michael Bednarek]

Is it possible to have in sequence a date value

I require four dates the same before sequencing the next date, so

01/01/11
01/01/11
01/01/11
01/01/11
02/01/11
02/01/11
02/01/11
02/01/11
03/01/11
03/01/11
03/01/11
03/01/11

A1: 1-Jan-2011
A2: =A1+.25
Copy A2 down.

May have unintended consequences.