DATE TROUBLE

[ssaifan]

I HAVE TWO DATES ////
start date
and end date

in cell a1 and a2..

then in cell a3 i enter break period.....say 24 months....

now i want to see a series of dates such that ...
start date 1 = start date
end date 1 = start date ( from above ) + 24 mths from cell a3...

then ....

start date 2 = start date 1
and end date 2 = start date 2 + 24 mths ....

and so on so forth ..
ho do i do this ..
pls help ..


sam

 

[shades]

Something like this?

If your new start date is in D1 and your months are in B3, then use this:

=DATE(YEAR(D1),MONTH(D1)+B3,DAY(D1))