+ Reply to Thread
Results 1 to 7 of 7

Incrementing the Maturity Date based on a Click Event OR Data Entry in Opening Date.

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Incrementing the Maturity Date based on a Click Event OR Data Entry in Opening Date.

    Incrementing the Maturity Date based on a Click Event OR Data Entry in Opening Date

    Dear Forum,

    I am in need of a small help to Automate Date Entries in the Maturity Date based on certain types of Investment Instruments like Deposit_Types.

    Deposit Types :
    Cumulative Deposit - Uneven Duration,Manual Entries for Opening as well as Maturity Date

    Recurring Deposit - Increment 6 Months in the Maturity Date on Click

    Quarterly Recurring Deposit - Increment 12 Months in the Maturity Date on Click

    Yearly Income Plan - Increment 12 Months in the Maturity Date on Click

    Half-Yearly Income Plan - Increment 12 Months in the Maturity Date on Click

    Quarterly Income Plan - Increment 12 Months in the Maturity Date on Click

    Monthly Income Plan - Increment 12 Months in the Maturity Date on Click

    National Savings Certificate - Fixed Difference of 6 yrs from Opening Date

    Kisan Vikas Patra - Fixed Difference of 8 yrs 7 months from Opening Date

    P.O. 5 Year R.D. ( Without Bonus ) - 5 yrs from Opening
    P.O. 5 Year R.D. ( With Bonus ) - 5 yrs from Opening

    P.O. Monthly Income Scheme - 6 yrs from Opening

    P.O. - 1 Year Time Deposit - 1 yrs from Opening
    P.O. - 2 Years Time Deposit - 2 yrs from Opening
    P.O. - 3 Years Time Deposit - 3 yrs from Opening
    P.O. - 5 Years Time Deposit - 5 yrs from Opening
    P.O. Sr. Citizens Savings Scheme - 5 yrs from Opening

    I need to have free access for manual entries for Cumulative Deposits with Uneven duration and Clicking to increment some Maturity Dates with a Fixed Interval but No-Fixed Timeline..

    ANd in some cases just Fixed Duration...

    Can some help with this to save time in entering loads of dates Automatically at some places and still leave a room for sweet sweats of Manual Labour at some places...

    Warm regards
    e4excel
    Attached Files Attached Files
    Last edited by e4excel; 09-20-2011 at 03:41 PM.

  2. #2
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Bump No Response

    Bump NO response

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Incrementing the Maturity Date based on a Click Event OR Data Entry in Opening Da

    Please Login or Register  to view this content.
    I was trying to do something like that but the problem is that the Target cell does not contain the Case Values..so please correct my snytax..

  4. #4
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Bump No Response

    Bump No Response

  5. #5
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Incrementing the Maturity Date based on a Click Event OR Data Entry in Opening Da

    Dear Forum,

    IS there an iota of a possibility to Automate the Date Entry when the Fixed Difference is known...

    THis will really save time for large no of deposits..

    Regards
    e4excel

  6. #6
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Bump No Response

    Please someone ..!

  7. #7
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Incrementing the Maturity Date based on a Click Event OR Data Entry in Opening Da

    IS there a way to influence the Third Column based on the value of the first column when the info is entered in the second column?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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