I have a list grouped by the following formula.
=CONCATENATE(TEXT([Effective Date]+(5-WEEKDAY([Effective Date])),"mm/dd/yyyy")," - ",TEXT([Effective Date]+(11-WEEKDAY([Effective Date])),"mm/dd/yyyy"))
Which gives something like this: Week : 04/30/2015 - 05/06/2015 (5)
But the items are not grouped properly based on the effective date. It does work correctly for some dates but others are messed up.
Is there an efficient way to group the items with the date range? The starting day of the week must be a Thursday and ending in Wednesday.
The formula works when the starting day is Monday and ending day is Friday. But seems not to work for Thursday - Wednesday.