Hello,
I'm trying to do a task list, but incorporate a bit of MS Project.
I'm trying to write a formula that says the following:
If cell D4 is blank, then allow the user to type in a date manually, but if D4 contains a number, find that Row's Plan Start Date (E column) and add 1 day.
The goal is to establish a date if a task has a predecessor, so that, if the date changes on the "predecessor task", the date of this new task auto-adjusts to that new date then adds one (new start date).
Bonus points if we can automatically not count weekends!!
On the attached spreadsheet, I'm use the "Row" column (Column B) to dictate which task is the Predecessor.
I don't know if I should use an IF/THEN statement, or if a VLOOKUP would be the ticket?
I hope that makes sense.
See attached and any help is appreciated!
Bookmarks