LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George
 
Posts: n/a
Default incrementing mm/yy based on value in other cell

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatiing based on another cell Number_8 Excel Discussion (Misc queries) 3 March 13th 06 12:35 PM
how to set up one cell that assigns a value based on the value of another cell Joseph Excel Worksheet Functions 2 June 22nd 05 06:38 AM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Returning a Value to a Cell Based on a Range of Uncertain Size amc422 Excel Worksheet Functions 7 November 14th 04 03:03 PM


All times are GMT +1. The time now is 12:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"