Schedule dates

kojak43 · Feb 27th, 2002, 03:15 PM

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?

Anne Troy · Feb 28th, 2002, 04:11 AM

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.

Feb 28th, 2002, 04:11 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 03:15 PM	#1
kojak43 Board Regular Join Date: Feb 2002 Posts: 270	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?