incrementing mm/yy based on value in other cell

G

George

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top