+ Reply to Thread
Results 1 to 3 of 3

Timeline - fill sheet with the missing dates between given interval

  1. #1
    Registered User
    Join Date
    05-02-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    9

    Timeline - fill sheet with the missing dates between given interval

    I have the following Excel problem:


    I currently have this in sheet1 columns A,B,C:


    Date Time Worker
    04/04/2016 4,5 John
    05/04/2016 2 John
    06/04/2016 6,5 John
    07/04/2016 0 --
    08/04/2016 0,5 Charles
    08/04/2016 2 John
    08/04/2016 0,5 William
    09/04/2016 0 --
    10/04/2016 0 --
    11/04/2016 9 John
    11/04/2016 3,75 William


    I also have:
    The Creation date of Project In cell E1 : 28/03/2016
    The Actual start of Project In cell E2: 29/03/2016
    The Today date In cell E3 (let's consider today date is the one i show next): 13/04/2016


    What I want in sheet2:

    Choose the earliest date between Creation and Actual start of Project, which in this case is 28/03/2016
    Then add the missing dates with 0 Time and -- Worker until it reaches the Today date.
    It should look like this after all done:

    Date Time Worker
    28/03/2016 0 --
    29/03/2016 0 --
    30/03/2016 0 --
    31/03/2016 0 --
    01/04/2016 0 --
    02/04/2016 0 --
    03/04/2016 0 --
    04/04/2016 4,5 John
    05/04/2016 2 John
    06/04/2016 6,5 John
    07/04/2016 0 --
    08/04/2016 0,5 Charles
    08/04/2016 2 John
    08/04/2016 0,5 William
    09/04/2016 0 --
    10/04/2016 0 --
    11/04/2016 9 John
    11/04/2016 3,75 William
    12/04/2016 0 --
    13/04/2016 0 --


    It is the continuation of a problem i had but only detected now:
    http://stackoverflow.com/questions/3...-add-date-to-c
    Looking for a excel-vba macro solution because i believe it's the only way to do it.
    I'm new to VBA and stuck with this problem and all the help means a lot to me!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Timeline - fill sheet with the missing dates between given interval

    Carlos, welcome to the forum

    It is almost always better if you can upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-02-2016
    Location
    Portugal
    MS-Off Ver
    2013
    Posts
    9

    Re: Timeline - fill sheet with the missing dates between given interval

    I uploaded an example with slightly different values with what I have.
    Attached Files Attached Files

+ 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. Replies: 16
    Last Post: 11-23-2019, 01:41 PM
  2. fill 2numbers in between with an interval
    By Michael_BU in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-15-2014, 03:42 AM
  3. Replies: 3
    Last Post: 07-29-2013, 06:28 AM
  4. Fill in missing gaps in dates
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2013, 10:43 AM
  5. [SOLVED] Auto Fill "Missing" based on two dates values
    By Tejas.T in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-31-2012, 04:22 AM
  6. Fill Missing Dates in Sequence
    By dirge in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2010, 06:33 AM
  7. Find missing dates in a sheet
    By alvin Kuiper in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2006, 10:55 AM

Tags for this Thread

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