Results 1 to 4 of 4

Calculating Maturity of CD by month

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Texas, San Antonio
    MS-Off Ver
    Excel 2007
    Posts
    57

    Calculating Maturity of CD by month

    Hello all,

    I have been working on a formula to help me calculate the month a CD would mature in a given year.

    For example I would like to know when a 13 month CD would mature in the year of 2056

    I have written the this to allow me to select the end of the year I want
    cell p45 is in months

    DATE(YEAR(EDATE(DATE(YEAR(NOW()),1,1),(P45))),12,31)

    But I am having problems figuring out what month a CD matures in a given year.

    I have attached the excel sheet I am using.

    Any help would be appreciated

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Calculating Trading Days Till Maturity
    By faylorst in forum Excel General
    Replies: 0
    Last Post: 03-09-2011, 01:20 PM
  2. [SOLVED] maturity schedule fixed inc securities by month, quarter and year
    By maturity schedule in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-31-2006, 07:10 PM
  3. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 01:05 AM
  4. [SOLVED] Calculating recurring date in following month, calculating # days in that period
    By Walterius in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 12:05 AM
  5. Replies: 6
    Last Post: 09-05-2005, 10:05 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