Project completion T-minus date

Morris R

Hello - Thank you in advance

Requesting a column formula in my project sheet.

I have a "Project completion" date as well as tasks that work back by week (can be days if easier). I would like to be able to enter any "Project completion" date and ensure the tasks change based on that date.

IE: Project completion is August 12th and Task A has to be completed 4 weeks earlier I would like the task to show a start date of September 12th (or 30 days earlier)

Paul Newcome

I would suggest relocating to a sheet summary field so that you can make it a column formula.

When using a number of days, it is a simple subtraction.

=[Launch Date]# - [T-Days]@row

Paul Newcome

Are you able to provide a screenshot for context? Do you have a column to indicate when the task needs to be completed in relation to the project end date?

Morris R

Morris R

Yes thank you

To clarify:

I have project COMPLETION date and would like to work backwards to individual subtasks either by week or by day (I created a column for both)

• LAUNCH is 8/1
• Subtask 1 occurs 32 weeks before that (or 128 days)
• I would want to put that formula in the "start" column and make it a column formula since i have a lot of tasks
• I could relocate the Launch date if this causes an issue since its in the same column

Paul Newcome

I would suggest relocating to a sheet summary field so that you can make it a column formula.

When using a number of days, it is a simple subtraction.

=[Launch Date]# - [T-Days]@row

Morris R

Paul Thank you that worked

I knew it was simple enough but needed that extra help!

Paul Newcome

Happy to help. 👍️