Want to split week in monthwise (help)!!!

Hi guys,
I want a solution.
I have a excel sheet with dates displayed in weeks.the dates are taken from the sheet 1.And its added with 4 so that a column has the week's start date and the end date.I have separated this into different week numbers.
Now my problem is ,In certain weeks say week 9 (attached sheet) the week starts with July and ends with august.In these cases I want the week to be split into 2 columns month-wise .i.e Jul 29 to 31 in one column and aug 1 to 2 in another column.

How can I do this?
can anyone help me please.