Hi All,

I have a long list of data split by week(A1) with the relevant total in the next cell (B1):

29/04/2013 74
06/05/2013 31
13/05/2013 53
20/05/2013 69
27/05/2013 63
03/06/2013 41
10/06/2013 42
17/06/2013 67
24/06/2013 54
01/07/2013 98
08/07/2013 44
15/07/2013 55

The issue I've got is that I want to split the data into Month's however some weeks overlap between months.

Is there any sort of formula that would split the week down into 7 days and the be able to work out how many days in that week were in the relevant month?

I can't really think of another way to do it.

Any help greatly appreciated as always.

Thanks.