Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Schedule dates

  1. #1
    Board Regular kojak43's Avatar
    Join Date
    Feb 2002
    Posts
    270
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I asked previously how to schedule workdays with an open deadline.

    Now I want to automate the entry of dates assuming a given deadline. I want Excel to determine the numbers of days from start to finish, then to allocate a date to a particular task.

    Lets say a task has 10 steps and I have but 4 days to produce the final job. I want Excel to divide up the days into the 10 steps. Some steps will have to be accomplished on the same date to finish on time. At this point I do not care which steps are double or tripled for a given date.

    Any guidance?

  2. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hmm...no one answered? Do a search for ["gantt chart" excel] (without the brackets and WITH the quotes) on Yahoo. There are downloadable files out there for just this thing, I'm sure you'll find it. However, as I recall, you'd have to enter each task separately, not have Excel do that for you. But I'm not sure. Let me know if you CANNOT find that file.
    ~Anne Troy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •