date calculation

[Ekta]

Hi Folks, 

Please help me to solve this--

 I have a column of dates:

Date 1               today's date        Output 

2018-10-10       2019-05-03          previous week
2019-04-29       2019-05-03          this week
2019-04-28       2019-05-03           last week

2019-04-22       2019-05-03           last week
2019-05-05       2019-05-03           this week

2019-05-06       2019-05-03            next week

2019-05-12       2019-05-03             next week
2019-05-09        2019-05-03            next week

I have only Date 1 as my input and i need to categorize it into 4 categories  which is previous week , this week, last week , next week.

this week starts from ... monday to sunday ie- from 29-05-2019 to 05-05-2019

next week starts from 6/may/2019 to 12/may /2019

last week starts from 22/april/2019 to 28/april/2019

rest all can be categorized as previous week.

Please help me with it.

Thank you so much in advance

[yalmar_m]

Dear @Ekta,

Please find my proposed solution attachted.

Does this work for you?

Best,
Yalmar

[Ekta]

Thanks a lot Yalmar ,  i also need one more category which is last week .. I am unable to write any formula for it.. please help me with it .. last week is one week prior to this week 

[yalmar_m · Accepted solution]

@Ekta 

Changed it!

[Ekta]

Thanks a lot :)