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
Solved! Go to Solution.
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
Thanks a lot :)