wierd timeseries

[West]

looking for a slick way to create a timeseries - problem is that I onl
need a cell for the year month and 1st or 16th day of each month. ie

2004-11-01
2004-11-16
2004-12-01
..
..
..and so on...

 

[Bob Phillips]

West,

Put this formula in your first cell, then copy down


=DATE(2004,10+INT((ROW(A1)+1)/2),(MOD(ROW(A1),2)<>0)*1+(MOD(ROW(A1),2)=0)*16
)
--

HTH

RP
(remove nothere from the email address if mailing direct)