Date Formulas - Expert Needed ;)

[Bennets04]

Hi all,

So i have a long column of date data (01/10/2018 etc) in Column A:A and what I'm trying to do is have Column B:B return back the following criteria:

Last Week (Which is the date in A:A is in the last 7 days)
Last Week -1 (Date in A:A is from the week prior to last)
Last Week -2 etc
Last Week -3 etc
Last Week -4 etc

I'm then planning on using that column to pivot and display the data.

Anyone had this before or fancy a little challenge assisting

Thank you in advance
Steve

 

[Bennets04]

Scrap that I have been able to do it with an index and match and a date formula to capture the start of the week!