Formula for Calculating Dates

System

I need formula to calculate a date to start checking on a column example
Installation date, need to add 2 weeks prior to start follow up to upcoming information (This will be on the left of the Installation date column)


This discussion was created from comments split from: Calculate Future Date.

@SPark

If I'm understanding your question correctly-- are you saying you need a formula that calculates 2 weeks before the install date?

=[Installation Date]@row-14

Should populate your install date - 14 days

Melissa Frost

I need formula to calculate a date to start checking on a column example

Installation date, need to add 2 weeks prior to start follow up to upcoming information (This will be on the left of the Installation date column)

@SPark

If I'm understanding your question correctly-- are you saying you need a formula that calculates 2 weeks before the install date?

=[Installation Date]@row-14

Should populate your install date - 14 days

Paul Newcome

@Melissa Frost

I agree with @Spark@Spark's solution. Were you able to get it working?

Melissa Frost

Yes thanks!

Paul Newcome

Excellent! Please don't forget to mark the most appropriate response(s) as "helpful" so that others looking for a similar solution know that one can be found here.