End Date minus x#of days =start date

Andrea Payne

Hello!

I am trying to enter a formula in a group of rows to have the end date -180days = start date column, but i've tried several different formulas and they all give me an error? Does the dependency to the parent row cause any issues for this - the sheet has 400+rows and i only need the formula in ~7 of them to equal the start date minus the end date = XX

Thank-you,

Paul Newcome

Try something along the lines of...

=[End Date]@row - 180

Paul Newcome

Are you getting an incorrect date, an error, or something else?

If you have dependencies turned on and referencing that column, you will not be able to use formulas. You would need to use the duration column.

Paul Newcome

Try something along the lines of...

=[End Date]@row - 180

Andrea Payne

Hello Paul,

Thanks for answering my question. I tried that entered in the "start date" column but what am i doing wrong - it's not calculating it from the end date?

Paul Newcome

Are you getting an incorrect date, an error, or something else?

If you have dependencies turned on and referencing that column, you will not be able to use formulas. You would need to use the duration column.