How to enter a task start date based on the end date of a previous task. LONG

[abuchanan]

I am trying to figure out how to allow data to be entered into an excel cell based on a previous data. This is a TASK monitoring spreadsheet.

You enter each task, and give an estimated end date for the task. The task is tracked, and once completed, an ACTUAL end date is entered. You can check to see if you're ahead or behind schedule... and also check to see how accurate your estimated end day way.

I want to allow the end user to either manually enter the start date or have the option to say the start date is dependent on the actually end date of a previous task.

This is MUCH easier to show in a sample workbook which I have attached.

I've already asked for previous help with this project, and apologize I have so many question. I used to work in excel ALL THE TIME, but that was over five years ago. As I gotten older, I've lost brain cells!!!!! . Thanks in advance for any help!

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1		Task					ESTIMATED		CALCULATED		ACTUAL
2		Task	Code Number	Person	Start Date	Dependent on?	END DATE	NUM DAYS	END DATE	# DAYS	End Date	# Days	Start Date Dependend on End Date of:
3		Task 1			Mon 5/01/23		6/2/23		Fri, Jun, 2, 23	24
4		Task 2			Tue 5/02/23			5	Tue, May, 9, 23	5
5		Task 3					6/2/23		Fri, Jun, 2, 23	32200
6		Task 4					6/2/23		Fri, Jun, 2, 23	32200
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Sheet1

Cell Formulas
Range	Formula
I3:I6	I3	=IF(AND(G3="", NOT(ISBLANK(H3))), WORKDAY(E3, J3), IF(AND(G3<>"", H3=""), G3, ""))
J3:J4	J3	=IF(AND(G3<>"", H3=""), (NETWORKDAYS(E3,I3)-1), IF(AND(G3="", H3<>""), H3, ""))
J5:J6	J5	=IF(AND(G5<>"", H5=""), NETWORKDAYS(E5,I5), IF(AND(G5="", H5<>""), H5, ""))

 

[abuchanan]

Anyone have ideas on this? Thanks