Formula to calculate maturity date

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Formula to calculate maturity date

  1. #1
    Board Regular mrnacar's Avatar
    Join Date
    Jan 2010
    Location
    Guam
    Posts
    184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    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.

User Tag List

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