I have the following columns – Week of Month, Month, Year, Date, & Days in Week.
I am trying to show in the column “Days in Week” in this format: 1 – 4, 5 – 11, etc.
In other words, I want the range of the days in that week to go into the column “Days in Week”. Refer to the picture below where I show the results that I am looking for (don’t pay any attention to the different colors):

The code that I am using only results in 1 – 31 which are the range of days in that month which looks like this:

Days in Week = IF(‘Date'[Year] = ‘Date'[Year] && ‘Date'[Month] = ‘Date'[Month] && ‘Date'[Adjusted Week Of Month] = ‘Date'[Adjusted Week Of Month], MIN(‘Date'[Day]) & ” – ” & MAX(‘Date'[Day]), “”)

Any and all help is appreciated!