+ Reply to Thread
Results 1 to 3 of 3

Button Macro To Add Years To Date

  1. #1
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Question Button Macro To Add Years To Date

    Hello, this should be easy, but I'm having trouble nonetheless:

    Cell C6 receives a date in this format: December 4, 2012
    Cell C7 receives data in this format: 3 Years

    I need a macro for my button to add the number of years in Cell C7 to the date in Cell C6 and display the date into Cell C8.

    How do I do this?
    There is so much good in the worst of us,
    And so much bad in the best of us,
    That it hardly behooves any of us
    To talk about the rest of us.

  2. #2
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Button Macro To Add Years To Date

    try it
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor swordswinger710's Avatar
    Join Date
    02-20-2008
    Location
    Bright, Canada
    MS-Off Ver
    2010
    Posts
    845

    Re: Button Macro To Add Years To Date

    That is beautiful, thank you!

+ 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