With your 1st date in A1:

In A2 enter and fill down =IF(A1<"",EOMONTH(A1,1),"")

JPreeshl wrote:
I am trying to get a dates to fill in after typing in the first one.
I need
if for loan payment schedules, work schedules, etc. If I type in
1/31/05 in
the first cell I would like 2/28/05 in the next cell, 3/31/05 in the
next
etc. I can't figure out a formula to do this, is there a way?
Jeff