series / date help

[fordguy]

I understanding using the fill handle and the series command, But what i
need and cant get excel to do is to do a colum of this
01/10/03
01/25/03
02/10/03
02/25/03

with those exact dates add the month as it goes along ,u cant add 15
because of the different months have different days. and if drag the
fill handle down it just repeats the above.

 

[AH]

Hi fordguy,

You can use this formula to fill the series in the way you want:

=IF(DAY(A4)=10,DATE(YEAR(A4),MONTH(A4),25),DATE(YEAR(A4),MONTH(A4)+1,10))

Just paste this below the last date you have and fill it down as long as
you want. In my case the last date was in A4 and I copied this to A5 ->.

- Asser

 

[fordguy]

thank you that worke