Split rows based on complex conditions

adeel726 , Not very clear. You can divide at the day level and then you can use a calendar/date table that has weeks to display data at the week level

Please find the attached file after signature, how to divide in days