How do you add one date to another? I type in 1/31/05 in A1 and I.

[JPreeshl]

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

 

[2rrs]

With your 1st date in A1:

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

 

[CLR]

Type your first two month-ends in your top two cells...........then
highlight BOTH and grab the little black square in the lower right corner of
the lower one and drag it down as far as you want.........the cells should
fill automatically........

Vaya con Dios,
Chuck, CABGx3