A common scenario in many projects where you are working with dates is to have a group by weekday request. A customer asked for an publishing calendar in SharePoint, where we could say the published items per day of the week. There is a funny thing that happens when you group the items on that …