+ Reply to Thread
Results 1 to 4 of 4

Allocating activity according to date.

  1. #1
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Allocating activity according to date.

    I've attached a sample workbook with before and after examples, which will no doubt be clearer than my explanation here.

    But this is the problem I'm asking for help with.

    Blocks 1 to 20 have an input date and an output date. blocks 1 to 20 cannot accept a new input until the output date for that block has expired. Then I want to allocate the next available input date that falls after the expired output date.

    See the example, that will be clearer. Be sure to examine further down the sheet to see the expected changes as the first block runs 1 to 20 then on to 26 in the second block.

    Thanks for looking,
    Regards
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-10-2014
    Location
    UK
    MS-Off Ver
    2010
    Posts
    272

    Re: Allocating activity according to date.

    So, no takers ?
    I'd be interested to know why, is it too complicated a problem, not interesting enough or does it require too much time.

    I could really do with some help with this, if you need more info please just ask.

  3. #3
    Registered User
    Join Date
    12-05-2012
    Location
    USA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    31

    Re: Allocating activity according to date.

    Not quite sure what you are trying to do with this sheet?
    What is this for? If you don't mind me asking.

    Do you want dates to automatically appear in the output cells in relation to the Date Difference "Q1"?
    Last edited by Excel_Guy02; 12-28-2014 at 01:55 PM.

  4. #4
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,459

    Re: Allocating activity according to date.

    Why I13 can not be accepted to be block 1?
    Quang PT

+ 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] report the date of first activity
    By shaz0503 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 05-19-2014, 12:27 AM
  2. Get date of most recent activity
    By shdwfx in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-11-2014, 09:15 AM
  3. [SOLVED] Allocating a given date to a date range bucket: futures contract expiry
    By labogola in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-26-2013, 08:50 AM
  4. Activity Time Tracker to capture activity selected from dropdown list
    By dillibabu in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-24-2013, 01:10 PM
  5. Log and Date Stamp Activity????
    By paulea3 in forum Excel General
    Replies: 2
    Last Post: 02-18-2005, 04:58 AM

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