Project Based Template For Dates

Try this in C3 of your example and copy/drag down

Please Login or Register  to view this content.

I am assuming that you are using an Excel version higher than indicated in your profile because of the file type offered. Please update your profile if you are using a newer version.

This might work for you if you are using Excel 2010 or later:
Enter in C2 and fill down:

Formula:

Please Login or Register  to view this content.

This will also work if you don't have access to WORKDAY.INTL which allows you to specify what a weekend is:

Formula:

Please Login or Register  to view this content.

This might be one for newdoverman to finish out because I don't know what to do if the dependency changes.

Use this formula in cell C3:

Please Login or Register  to view this content.

Copy down to rows that have a Precedence task. Have fun with the inevitable circular references.

This changes things considerably. From your last message, I understand that there has to be a "Precedence" even if that "Precedence" is a repeat of previous precedencies. If that is the case then I think this will work: (If there isn't a precedence, what can be used for a start date??)

Formula:

Please Login or Register  to view this content.

	A	B	C	D	E	F	G
1	Task Name	Duration (Days)	Start Date	End Date	Precedence	% Completion	Status
2	Task 1	4	12/07/2015	16/07/2015
3	Task 2	5	20/07/2015	27/07/2015	Task 1
4	Task 3	3	20/07/2015	23/07/2015	Task 1

	A	B	C	D	E	F	G
1	Task Name	Duration (Days)	Start Date	End Date	Precedence	% Completion	Status
2	Task 1	4	12/07/2015	16/07/2015
3	Task 2	5	20/07/2015	27/07/2015	Task 1
4	Task 3	3	28/07/2015	31/07/2015	Task 2

Hi newdoverman ,

My apologies again. You have a valid question in (If there isn't a precedence, what can be used for a start date??). Here is the logic:

1) If the task name is blank, then no start date.
2) If the task name is completed and there is no dependency, then the start date should be the date after the end date of the previous task.
3) If the task name is completed and there is a dependency, then the start date should be the date after the end date of the dependency.

Appreciate all your help how it can be done.

@cyiangou
If you are looking for a solution to your problem using this thread then unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

I think that I may be on the right track with this formula. Only filling your worksheet with realistic data will tell if it works or not. Enter this formula in C3 and fill down (it is good to row 200).

Formula:

Please Login or Register  to view this content.

Amend the formula in d2 to the following and fill down:

Formula:

Please Login or Register  to view this content.

@cyianqou
Yes, I did look at your workbook.
I stated "If you are looking for a solution to your problem using this thread then unfortunately your post does not comply with Rule 2"

I could not tell if you were offering assistance or asking for it.

I got from your second paragraph that you were looking for assistance with a MAX formula in column G. If this is not correct, I apologize.