Results 1 to 3 of 3

Formula to calculate maturity date

This is a discussion on Formula to calculate maturity date within the Excel Questions forums, part of the Question Forums category; Can someone help? I need a formula to calculate maturity date based on term and first payment date. Example: A1 ...

  1. #1
    Board Regular mrnacar's Avatar
    Join Date
    Jan 2010
    Location
    Guam
    Posts
    184

    Default Formula to calculate maturity date

    Can someone help?

    I need a formula to calculate maturity date based on term and first payment date.

    Example:

    A1 = Term on Months: 24
    A2 = First Pymt Date: 1/5/2011
    A3 = Maturity Date: 12/5/2012 <------Need formula here.
    I am no Guru.
    Mrexcel is my best friend.
    Google is my second best friend.
    But I still wish I had your knowledge.

    I use version 2007.

  2. #2
    Board Regular
    Join Date
    Nov 2011
    Posts
    67

    Default Re: Formula to calculate maturity date

    Try...

    Code:
    =DATE(YEAR(A2),MONTH(A2) + A1 - 1, DAY(A2))
    Last edited by rosenbe; Nov 24th, 2011 at 07:34 PM.

  3. #3
    Board Regular mrnacar's Avatar
    Join Date
    Jan 2010
    Location
    Guam
    Posts
    184

    Default Re: Formula to calculate maturity date

    It works! Thank you very much.
    I am no Guru.
    Mrexcel is my best friend.
    Google is my second best friend.
    But I still wish I had your knowledge.

    I use version 2007.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com