+ Reply to Thread
Results 1 to 4 of 4

How do I Auto Populate a Calendar Series per Start and End Date?

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    65

    Exclamation How do I Auto Populate a Calendar Series per Start and End Date?

    I am hoping I can get some help here. If you see on the attach spreadsheet.
    I am wanting for the Calendar dates to automatically populate on another sheet.
    If you look at the Sheet called Schedule and see Cell B3 & B4 for the Start and End Date.
    I would like whatever dates I enter to be populated on Sheets called Internal, Operations, Executive & Customer.
    I currently have a formula on the Internal Sheet, on Cell D3 and E3 that gives me the calendar scheduled by me having to copy the formula across, for it to function. But normally the customer working on this spreadsheet will get it blank as in the Operation sheet and once they enter the dates on Schedule sheet I would like for the calendar dates to automatically update on the sheets according to the start and end dates put on the Schedule Sheet, with a +7 date per Cell.

    Hope this makes sense!! Thank you and look forward to your help.WW Working Book v1.4.xlsx

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,558

    Re: How do I Auto Populate a Calendar Series per Start and End Date?

    Put this formula in D3:

    =IF(Schedule!$B$3="","",Schedule!$B$3)

    and this one in E3:

    =IF(OR(D3="",Schedule!$B$4=""),"",IF(D3+7<=Schedule!$B$4,D3+7,""))

    Then copy E3 across as far as you need to (eg AZ3).

    If there are no dates in B3 or B4 (or if B4 is less than B3, as you have it now), then the cells will appear blank. You can then copy this range range of cells into the other sheets, starting from D3.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    10-22-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    65

    Re: How do I Auto Populate a Calendar Series per Start and End Date?

    I copied the as you mention but in Cell E3 the dates do not populate at all.
    Cell D3 worked out fine.

    Inez15

  4. #4
    Registered User
    Join Date
    10-22-2012
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    65

    Re: How do I Auto Populate a Calendar Series per Start and End Date?

    I got it to work - Thank you.
    So the only way for this function would be to populate the formula far enough out so it captures enough dates depending on the length of the project.

    Thank you so much Pete

+ 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