I need a formula that will dynamically change as time goes on and shows what week a previous [Date Created] will fall in. For example, today is 11/3, so any day between 11/1 and 11/3 would be week 1, any day between 10/25 - 10/31 would be week 2, any day between 10/18 - 10/24 would be week 3, etc.
If today was 11/10 the the dates between 11/8 - 11/10 would now be week 1, 11/1 - 11/7 would be week 2, etc.
I need to identify at least 6 rolling weeks. I don't necessarily need the word "weeks" included; just a way to differentiate between weeks 1 - 6. They can be numeric/text, doesn't matter.
Thanks for the help.