I have a table called tasks that has a listing of common tasks for projects. The table has the field for due date as to when the specific task is due. I also have a table for projects that has Project End Date for each project. Is there a way to have the due date for each task in the task table to populate the due date based off of the project end date.
Project End Date 6/25 Server Installation is due 98 days before the project end date, therefore it is due 3/19.
Project End Date 6/25 Interface Testing is due 49 days before the project end date, therefore it is due 5/7.
Each task has its own due date. Is there a formula that can give me an due date for each task based off of the Project End Date.