Working dates backwards.

[Andreja]

Can anyone help
I have a job to do and I hope you can help me.

I have a column with a renewal date and need to calculate exactly 8 weeks back to come up with a date (e.g. start date)

2nd question
I know how to use TRUE or FALSE function. From that start date I need to have a formula to capture the inputted date to say it's either gone beyond 8 weeks or has fallen inside 8 weeks.

I hope this makes sense and hope you can help me.

Many thanks in advance

 

[BobUmlas]

If renewal date is in D3, then 8 weeks back is =D3-56
If inputted date is in D4, then =IF(D4>D3-56,"Beyond","Inside")&" 8 weeks"

 

[Andreja]

A massive thank you. Unfortunately work related. thanks again, very much appreciated