+ Reply to Thread
Results 1 to 5 of 5

How to determine 7 calendar days from a input date in another excel tab?

  1. #1
    Registered User
    Join Date
    06-27-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    47

    How to determine 7 calendar days from a input date in another excel tab?

    I have input sheet containing dates . I would like to find out what is the 7 calendar days from that input days.
    The output file have all other attributes exactly same as input file, except the date. This can not be done manually
    because the original file contains ~600 records. Any suggestion .

    See the attached file contain 2 sample records.


    Input
    =====
    Perform Name--> engine#-->Date-->system
    =======================================
    David Smith---->ACB098-->2/10/2015-->Laptop

    OUTPUT
    ======
    Perform Name--> engine#-->Date-->system
    ========================================
    David Smith---->ACB098-->2/10/2015-->Laptop
    David Smith---->ACB098-->2/9/2015-->Laptop
    David Smith---->ACB098-->2/8/2015-->Laptop
    David Smith---->ACB098-->2/7/2015-->Laptop
    David Smith---->ACB098-->2/6/2015-->Laptop
    David Smith---->ACB098-->2/5/2015-->Laptop
    David Smith---->ACB098-->2/4/2015-->Laptop
    Attached Files Attached Files

  2. #2
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,810

    Re: How to determine 7 calendar days from a input date in another excel tab?

    Try:
    Please Login or Register  to view this content.
    You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
    Practice makes perfect. I'm very far from perfect so I'm still practising.

  3. #3
    Registered User
    Join Date
    06-27-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    47

    Re: How to determine 7 calendar days from a input date in another excel tab?

    I am getting the below error message

    Run-time error "9":

    Subscript out of range

    When click on debug, the below line highlighted


    Range("A" & rDate.Row & ":B" & rDate.Row).Copy Sheets("Output").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)

  4. #4
    Registered User
    Join Date
    06-27-2015
    Location
    USA
    MS-Off Ver
    2010
    Posts
    47

    Re: How to determine 7 calendar days from a input date in another excel tab?

    I did not create a "OUTPUT" Tab . That's why I was getting error message. Your code is absolutely working. You are genius. Thank you so much.
    Let me know how to put 5* on this solution.

  5. #5
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 2013
    Posts
    7,810

    Re: How to determine 7 calendar days from a input date in another excel tab?

    You are very welcome. You can "put 5* on this solution" by clicking the Star symbol at the bottom left of my post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Determine # of days between two dates for each calendar year
    By gmazz in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-12-2015, 03:57 PM
  2. Determine number of days covered for a certain date range
    By jayp_ in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-28-2014, 05:19 AM
  3. [SOLVED] Input days into calendar template - VBA
    By wrightyrx7 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2014, 04:36 AM
  4. Input a year to determine the start date for 4-4-5 Calendar Year.
    By mak1176 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-25-2013, 10:34 AM
  5. [SOLVED] Determine date based on request date meanwhile falls on particular days
    By Hikari in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-18-2013, 09:37 AM
  6. Formula/Macro to determine when 90 days have passed from pre-defined date
    By maacmaac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-23-2011, 12:23 AM
  7. Replies: 5
    Last Post: 02-11-2010, 05:13 PM

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