+ Reply to Thread
Results 1 to 5 of 5

Calculate average until date = maturity

  1. #1
    Registered User
    Join Date
    12-10-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    45

    Calculate average until date = maturity

    Here is what my excel table looks like
    A B C D E F G K L M N
    1 2012 2013 2014 2015 2016 2017 2018 Maturity 2016 Today's Year 2013
    2 1% 3% 3.5% 2.1% 5.6% 4.3% 3.4%
    3

    I have about 15 series of rows with different numbers that go from 2012 to 2018. I would like to calculate the average for each row from today's year to maturity. In this case the average of numbers would go from B2 to E2. The maturity sometimes changes and well as today's year. I am new to VBA programming and I am trying to learn by doing. The books just do not help me.

    Thank you,

    Todd

  2. #2
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Calculate average until date = maturity

    This is hard to understand

    A B C D E F G K L M N
    1 2012 2013 2014 2015 2016 2017 2018 Maturity 2016 Today's Year 2013
    2 1% 3% 3.5% 2.1% 5.6% 4.3% 3.4%
    3
    Maybe this:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-10-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    45

    Re: Calculate average until date = maturity

    Maybe the attached will help. I am trying to write a macro that will calculate all of the averages in Column J. I would like to be able to change the maturity year and update the average values.

    Thanks for the above code but could not get it to work.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    12-10-2013
    Location
    usa
    MS-Off Ver
    Excel 2013
    Posts
    45

    Re: Calculate average until date = maturity

    I got to work. Thank you stnkynts

  5. #5
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Calculate average until date = maturity

    Lol yeah, I would have never gotten that from your first post.

    Try this:
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 6
    Last Post: 10-03-2011, 04:26 PM
  2. Calculate Average Using Date Range
    By LisaG in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-02-2008, 11:39 AM
  3. Calculate maturity date on loan
    By pforce in forum Excel General
    Replies: 1
    Last Post: 07-19-2007, 06:38 AM
  4. [SOLVED] Does anyone know how to calculate Yield to Maturity using Exel?
    By TL1525 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2006, 07:50 PM
  5. [SOLVED] Calculate difference between 2 date and times with average
    By Aeryn635 in forum Excel General
    Replies: 1
    Last Post: 12-14-2005, 11:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1