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):