incrementing mm/yy based on value in other cell

[Guest]

I need to start a chart of mm/yy based on the value in A1. Then I need to
increment this value. There is a payment # in the B column that can be used,
if that helps.

Example:
A B
1 Jan-06 Month of first payment
(this is an value we input)

Month Pmt #
10 Jan-06 1 (this is just the value of A1)
11 Feb-06 2
12 Mar-06 3
13 Apr-06 4

The month/yr needs to continue for 120 months

Thanks

George

 

[Peo Sjoblom]

If you type in Jan-06 in A1 then the underlying value will be 01/06/06 if
the current year is 2006 (otherwise it will be whatever current year your
computer clock has) so if you type it that way I'd suggest you change it to
01/01/06 and use a custom format of mmm-yy, if you in A2 want Feb-06 and so
on you can put this in A2

=DATE(YEAR(A1),MONTH(A1)+1,1)

now copy down to A120


--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[Guest]

That was the trick

Thank you very much

George