+ Reply to Thread
Results 1 to 2 of 2

Populating a calendar

  1. #1
    Registered User
    Join Date
    08-22-2012
    Location
    Bismarck, ND
    MS-Off Ver
    Excel 2010
    Posts
    7

    Populating a calendar

    Hello,

    I'm looking for help with a calendar based program. The issue goes like this:

    I am trying to project out into the future when an activity will occur, it's just like a changing your AC filter. Evey three months i want to show this occurring.
    The issue with this is that I can not figure out how to program this activity for several weeks or columns out in the future for each entry.

    So in Column F it tells me how many columns or weeks I progress into the furture repeatedly from the Start Date. At each stop I need to enter in the number of hours like shown below.

    Anyone able to direct me as to how to figure this out?

    Column F Column G Column H Column I Column J Column K Column L Column M
    Frequency Start Date Number of hours 1/2/2012 1/9/2012 1/16/2012 1/23/2012 1/30/2012
    in weeks

    2 1/9/12 2 2 2

    1 1/2/12 6 6 6 6 6 6

    3 1/2/12 3 3 3

    If I did it right there should be an attachment that is a much better view.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-22-2012
    Location
    Bismarck, ND
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Populating a calendar

    It obviously didn't load onto the thread post as I typed it. The excel spreadsheet is a clear example of what it looks like.

+ 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