+ Reply to Thread
Results 1 to 5 of 5

Calculate end date base don Start date + 6 months

  1. #1
    Registered User
    Join Date
    02-21-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2010
    Posts
    96

    Calculate end date base don Start date + 6 months

    Hi there. Hoping this is an easy solution.

    I have 2 textboxes we can call Textbox1 and Textbox2. Textbox 1 is a start date that the user enters and i would like Textbox 2 to change based on the date that is in Textbox 1. I want Textbox 2 to show an end date 6 months after the start date.

    Is this possible?

    I basically want to do the same thing EDate() does but in VBA

    Any help is appreciated
    Last edited by Spritz; 06-14-2013 at 01:46 PM.

  2. #2
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Calculate end date base don Start date + 6 months

    Here is an example. Click on the cell with the date.
    Attached Files Attached Files
    Gary's Student

  3. #3
    Forum Contributor Obsessed's Avatar
    Join Date
    05-22-2013
    Location
    Cincinnati, Ohio
    MS-Off Ver
    Excel 365
    Posts
    215

    Re: Calculate end date base don Start date + 6 months

    Assuming TextBox1 is A1 and TextBox2 is B1:

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    02-21-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Office 2010
    Posts
    96

    Re: Calculate end date base don Start date + 6 months

    Quote Originally Posted by Jakobshavn View Post
    Here is an example. Click on the cell with the date.
    Perfect. Thank you

    My textboxes were in a userform so i only needed the d1, d2 portion of it but it worked like a charm!

  5. #5
    Forum Expert Jakobshavn's Avatar
    Join Date
    08-17-2012
    Location
    Lakehurst, NJ, USA
    MS-Off Ver
    Excel 2007
    Posts
    1,970

    Re: Calculate end date base don Start date + 6 months

    Thanks for he feedback!

+ 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